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 All,
I'm new to powerbi. I want to create the historical plot of no. of overdue document.
Currenly, i can count Today overdue case by using Today() function in powerquery.
In the sample below, i can count no. of overdue cases = 2 cases.
Today Status | |
NextReview | Overdue Flag |
15-Oct-20 | No |
15-May-20 | No |
15-Jan-21 | No |
15-Dec-20 | No |
15-Mar-20 | Yes |
11-Mar-20 | Yes |
However, with this methold i cannot see historical trend of overdue cases. What i want to achieve is something like this.
Overdue Status as at | |||||||
Deadline | 24/02/20 | 02/03/20 | 09/03/20 | 16/03/20 | 23/03/20 | 30/03/20 | 06/04/20 |
25-Feb-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
27-Feb-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
01-Mar-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
26-Feb-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
31-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue |
29-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
29-Apr-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue |
17-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
25-Feb-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
25-Feb-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
25-Feb-20 | Not Overdue | Overdue | Overdue | Overdue | Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
27-Mar-20 | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Not Overdue | Overdue | Overdue |
This is the final result that i want to see but i don't want to create calculate column to flag the status of everyday date i want to count the overdue case.
Date | No. of Overdue Case |
24/02/20 | 0 |
02/03/20 | 7 |
09/03/20 | 7 |
16/03/20 | 7 |
23/03/20 | 8 |
30/03/20 | 18 |
06/04/20 | 19 |
Is there anyway to acheive this ?
Thanks !
Solved! Go to Solution.
@Anonymous
You may refer to the following post.
@Anonymous
You may refer to the following post.
Hello @Anonymous ,
What is the datatable structure?
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedIn
Hi @vivran22 ,
I am the authur's colleague.
Our full data structure look like this.
We simplify the data in the question above. Our main forcus is the table on the left (Appinfo_Incoming).
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 |