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.
Hello Community,
I am looking to calculate the daily average incidents for each quarter, and I am not quite sure how to go about it. I have calculcated the number of incidents per quarter using DISTINCTCOUNT('Table'[incidents]) :
I am doing a YoY quarterly comparison, and my fiscal year starts in October, so Q1 =Oct, Nov, Dec.
What I don't know how to do is now divide the number of incidents by the total number of days in the quarter.
I have a date table, and one column does contain the number of days in the month, my fiscal quarter is also in the date table.
Thank you for the help,
Denisse
Solved! Go to Solution.
Hello, I solved it using the following:
Hello, I solved it using the following:
Hello,
Are you able to share your report file/dataset or at least a part of it? It would be convenient to test out some possibilties.
Best regards,
I do not know how to share my report file here, i don't know how to attach it. Would you know?
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |