Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

-

-
  • SergioSilvaPT's avatar
    SergioSilvaPT
    4 years ago

    Hi Anonymous ,

     

    Given the example that you sent me in PM:

     

    I think the following measure could solve your problem:

     

    Revenue = (SUM(Table[Unit price]) - SUM(Table[Cost price])) * quantity

     

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi Anonymous,

I think we do not understand the problem.

Where do you have to multiply numbers with letters?

You have to distinguish between DAX and Power Query, you can't use both at the same time.

 

A simple DAX measure could look like this.

 

revenue = SUM('Table'[net sale price]) - SUM('Table'[cost price])