calculate if current month performs better the previous

Anonymous — Thu, 22 Dec 2022 18:14:58 GMT

I have such table:

It will always take 3 latest month, I need to display new column in this table that will show is the month performed better or worse then previous based on spending value. I can't assign month names or number as the table automatically takes 3 latest month

Re: calculate if current month performs better the previous

amitchandak — Fri, 23 Dec 2022 04:20:36 GMT

Anonymous , If you have date or you can create one with help from month and year. You can join date with the date of date table and use Time Intelligence

example measures

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

Or try the new Offset function

Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

topic calculate if current month performs better the previous in DAX Commands and Tips

calculate if current month performs better the previous

Re: calculate if current month performs better the previous