Forum Discussion

Nino1's avatar
Nino1
Frequent Visitor
4 years ago
Solved

DAX

Hello everyone   I'm a new user of Power bi and need your help.   I have two tables: one for total revenue and one for exchange rate.   date currency total revenue total revenue in USD  ...
  • technolog's avatar
    technolog
    4 years ago

    Hi!

    You should use:

    SUM([total revenue])*RELATED([Currency Rate]) - 

    CALCULATE(SUM([revenue total])*RELATED([Currency Rate]) , DATEADD('Calendar'[Date], -1, MONTH))

technolog's avatar
technolog
Icon for Super User rankSuper User
4 years ago

Hi!

You should use:

SUM([total revenue])*RELATED([Currency Rate]) - 

CALCULATE(SUM([revenue total])*RELATED([Currency Rate]) , DATEADD('Calendar'[Date], -1, MONTH))

Nino1's avatar
Nino1
Frequent Visitor
4 years ago

Thank you very much!