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.
i have a case where i have to show a cumulative backlog of appilcations.
My case is: we receive applictions and we have a due date of 30 days if the staff asks for a extention the due date will be 45 days.
we need to show a cummulative backlog graph of applications that are overdue (i.e >30 days if extention not requested
> 45 days if extention requested )
it should be acting accordingly with the date slicer that is comming from other table where i ahve a connection with date the column and the application received date in over main table.
Assume your applictions data table is like
start date | received date | extention request |
10/1/2015 | 12/1/2015 | no |
1/1/2016 | 1/25/2016 | no |
2/1/2016 | 4/5/2016 | yes |
1/1/2017 | 1/5/2017 | no |
1/1/2017 | 2/25/2017 | yes |
1/1/2018 | 2/19/2018 | yes |
1/1/2015 | 10/1/2015 | no |
2/1/2017 | 3/5/2017 | no |
1/1/2018 | 2/10/2018 | no |
1/31/2018 | 3/10/2018 | no |
To get the count of rows which are overdue, Create measures
days between = DATEDIFF(MAX([start date]),MAX([received date]),DAY) count = CALCULATE(COUNTROWS(Sheet1),FILTER(Sheet1,
([extention request]="yes"&&[days between]>45)||
([extention request]="no"&&[days between]>30)))
To get cummulative sum of backlog of applications that are overdue
Create measures
cumulative = SUMX(FILTER(SUMMARIZE(ALLSELECTED(Sheet1),[received date],"countrosw",
CALCULATE(COUNTROWS(Sheet1),FILTER(Sheet1,[extention request]="yes"&&[days between1]>45
||[extention request]="no"&&[days between1]>30))),
[received date]<=MAX([received date])),
[countrosw])
Best Regards
Maggie
Hi,
Share a dataset and show the expected result in a Table format. Once the Table is ready, we can easily create an Area graph.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |