Forum Discussion
-
-
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
8 Replies
- mwegener
Most Valuable Professional
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]) - Ashish_Mathur
Super User
Why do you need to add a quantity column. Just simply add the Unit Price column.
- Signore_Ands
Advocate III
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?- Signore_Ands
to calculate Revenue you will need more data yes.
- selimovd
Hey Anonymous ,
where do you have to multiply numbers with letters? I don't understand that step.
Thank you and best regards
Denis
- SergioSilvaPT
Resolver V
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
