Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @Anonymous
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.