Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 last month. It should look something like this:
MonthYear Customers Difference
09-2018 400 20
08-2018 380 -10
07-2018 390 -50 etc.
I've tried numerous helpful tips from the forums and it resulted in nothing.
So far I've created a seperate measure for total amount of customers and used different formulas. No luck.
Am I overthinking things?
I would greatly appreciate a word of advice to advance further 🙂 If there is any additional information you might need, let me know.
Kind regards,
Daniël
Hey,
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |