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

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Signore_Ands
Icon for Advocate III rankAdvocate III
4 years ago

to calculate Revenue you will need more data yes.