+ Reply to Thread
Results 1 to 5 of 5

New measure on power query

  1. #1
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    177

    New measure on power query

    Hello everyone
    I'm trying to build a measure that subtract all sales by the seller value.
    I have the seller value on rows, and on values, i have several totals.
    Now i have to pick one this total and subtract with seller value. For example =[Sum of Valor Total 2]-[Sum of TTec]
    This Sum of TTec is in rows.
    Can you help me please? Cose next time i have to divide them both to give the %

    Tks in advance
    Pedro

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: New measure on power query

    Hi,

    Can you provide a sample workbook? I cannot follow your explanation of what it is you want and what exactly your table(s) look like, I'm afraid.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    177

    Re: New measure on power query

    It's kinda dificult to do it cose it's linked to several workbooks and links...
    Any other way?

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: New measure on power query

    You can't create measures in Power Query. Measures are created in Power Pivot, with DAX. Do you want to change your title to correct that?

  5. #5
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    177

    Re: New measure on power query

    I would but don't know how...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Pivot Measure so I can put a text field in If condition is not true
    By rv02 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-06-2016, 08:59 AM
  2. Replies: 0
    Last Post: 12-04-2015, 11:31 AM
  3. [SOLVED] Help Needed with Power Pivot Calculate Measure
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-13-2015, 10:09 AM
  4. [SOLVED] Create a measure in Power Pivot to divide by value in subtotal row of the PP
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-22-2015, 11:22 AM
  5. [SOLVED] RANK.EQ Function in Power Pivot Measure
    By rv02 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2015, 04:26 PM
  6. Excel Power pivot measure
    By eajustin15 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-12-2013, 05:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1