-

[SG12]

-

[SergioSilvaPT · Accepted solution]

Hi @SG12 ,

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]

Hi @SG12,

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])

[selimovd]

Hey @SG12 ,

where do you have to multiply numbers with letters? I don't understand that step.

Thank you and best regards

Denis

[Signore_Ands]

I take it you have a separate table that holds the transactions (with the quantities)?

Are you trying to multiple the quantities in a transaction table by the unit prices in the debtors table?

[SG12]

Thats what i'm trying to do but i don't have a "quantity" table for the debtors, all the tables you see above is what i have. Is it still possible or do i need to have quantity table to calculate the revenue per debtor. 

[Signore_Ands]

to calculate Revenue you will need more data yes.

[Ashish_Mathur]

Why do you need to add a quantity column.  Just simply add the Unit Price column.

[SG12]

Hi,

i haven't added it. it was just a example. Can you share your way of solving this?