Forum Discussion
Difference between last - current month results
Dear Power BI users, I'm relatively new to Power BI and am trying to learn as much as I can. Sadly im running into an issue. Im trying to create a column that compares current month customers to...
JosefPrakljacic
Solution Sage
Solution SageHey,
I would recommend that you have a propper data table in place.
Then I would use a combination of the functions CALCULATE and PreviousMonth in order to achive your desired result.
YourMeasure := CALCUALTE(CustomersCount,DATESBETWEEN(FIRSTDATE(TODAY),LASTDATE(TODAY)) -CALCULATE(CustomersCount,PREVIOUSMONTH(TODAY()))
Please don't forget to give a 👍 and accept the post as solution. (If it helped 😅)
Have a nice day!
BR,
Josef
Graz - Austria