Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Has anyone done something similar to my problem? I have a matrix table made by dimDate year and month for the upcoming 16 months starting from the current month.
Column overdue - its cases those deadline was in the past. Therefore, it is overdue and my table shows the overall count of them.
Due cases - its cases those deadline is in the future based on the deadline having a single relationship between dimdate table and my fact table deadline.
Availability - Static value meaning how many cases my team is able to handle
My methodology is shown in the attached table while predicted overdue can be negative.
Year | Month | Overdue | Due | Availibility (Static value) | Predicted Overdue |
2023 | 9 | 34 | 54 | 80 | |
2023 | 10 | 23 | 80 | (34+23)-80 | |
2023 | 11 | 35 | 80 | (34+23+35)-80 | |
2023 | 12 | 65 | 80 | (34+23+35+65)-80 | |
2024 | 01 | 43 | 80 | (34+23+35+65+43)-80 | |
2024 | 02 | 75 | 80 | (34+23+35+65+43+75)-80 |
Solved! Go to Solution.
Hi @miracle2023,
I've prepared the calculated columns which produce the same output as your screen print.
I've first added a helper column below:
Then, used that helper column in the dax formula for calculated column which produces your required result.
The pbix file is saved under the following link:
Hi @miracle2023,
I've prepared the calculated columns which produce the same output as your screen print.
I've first added a helper column below:
Then, used that helper column in the dax formula for calculated column which produces your required result.
The pbix file is saved under the following link:
Thank you very much for your help!
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |