Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone
I've tried to create a measure which calculates an average score for the current month (based on the latest data), previous month and the month before but the average is not correct as I manually checked it against the source data
My data is dummy data for testing which has;
2 years of data (2018 and 2019)
240 rows (10 for each month)
Each month shows the date format as dd/mm/yyyy (example 01/01/2018, 01/02/2018 etc) and is formatted in Power BI as "Date"
The measure I tried is below
Solved! Go to Solution.
Hi @Daniel_B ,
If your dates are not consecutive, you can create a calendar table.Then create a measure to calculate the average value of the last three months, and use the newly created calendar as the slicer.You can refer to the pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Daniel_B ,
If your dates are not consecutive, you can create a calendar table.Then create a measure to calculate the average value of the last three months, and use the newly created calendar as the slicer.You can refer to the pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
If possible, I'd like to learn how to make it so that if there is a calendar page filter that the user can choose the year and month and the data still show a comparison of the selected month in the selected year
Otherwise, just being able to see the latest 3 comparable months would be great
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |