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'
END

 

Thank you in advance!

Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

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

     

1 Reply

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

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