Forum Discussion

Ashley1's avatar
Ashley1
Frequent Visitor
2 years ago
Solved

Need help converting Tableau calculation to DAX formula

I know this is a very simple formula but I am not able to incorporate it in Power BI. Please help   IF ZN(SUM([TotalSales])) - LOOKUP(ZN(SUM([TotalSales])), -1)>0 THEN 'Surplus' ELSE 'Deficit' EN...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    IF (
    ISBLANK(SUM([TotalSales])) - CALCULATE(SUM([TotalSales]), PREVIOUSMONTH('Table'[Date])) > 0,
    "Surplus",
    "Deficit"
    )

     

Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

IF (
ISBLANK(SUM([TotalSales])) - CALCULATE(SUM([TotalSales]), PREVIOUSMONTH('Table'[Date])) > 0,
"Surplus",
"Deficit"
)