Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need a DAX expression to calculate:
CALCULATE(Table1[price] / Table1[exchangeRate]) * Table1[qty]),
FILTER by Table1[Code] NOT NULL AND Table1[OrderType] NOT 2
Cannot figure it out in DAX. I tried two seperate DAX's so I'd have:
LineValue = Table1[price] / Table1[exchangeRate]) * Table1[qty])
TotalValue = CALCULATE(SUM(Table1[LineValue]), FILTER(Table1, Table1[Code] <> BLANK() && Table1[OrderType] <> 2))
Solved! Go to Solution.
SOLVED - I was looking at the wrong date range, I will leave this code here if anyone needs to use it
SOLVED - I was looking at the wrong date range, I will leave this code here if anyone needs to use it