Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I am trying to create a burn down of orders past due which burn on the date that they are planned to ship. See my attached data and chart.
| Contract Date | Dock Date | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/8/2023 | 4/6/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/8/2023 | 4/6/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/10/2023 | 5/11/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/10/2023 | 5/11/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/10/2023 | 5/11/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/31/2023 | 6/2/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/31/2023 | 6/2/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 3/31/2023 | 6/2/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 4/10/2023 | 4/10/2023 | |
HARNESS ASSEMBLY, ENGINE CONTROL | 4/10/2023 | 4/10/2023 |
Date (MM/DD) | 3/27/23 | 4/3/23 | 4/10/23 | 4/17/23 | 4/24/23 | 5/1/23 | 5/8/23 | 5/15/23 | 5/22/23 | 5/29/23 | 6/5/23 | 6/12/23 | 6/19/23 |
Actual count of overdue and future overdue | 8 | ||||||||||||
Forecast count of overdue lines | 6 | 6 | 6 | 6 | 6 | 3 | 3 | 3 | 0 | 0 | 0 | 0 |
Hi @AppleUSN,
It seems like you want to analysis the date range that defined by multiple date fields. For this scenario, you can take a look at the Gregs’ blog 'start date' 'end date' part of helps.
In addition, you can also try to create a expand table to expand all the detail date records into the ranges to help power accurately map these records.
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I actually found a solution to what I was trying to do. I had to make some tweaks to it as it wasnt showing as I expected.
Hi @AppleUSN,
I'm glad to hear you find the solution and share the expressions here, they should help with other who faced the similar scenarios.
For Dax study, you can also take a look at the following link about learning/train with Dax language:
Use DAX in Power BI Desktop - Training | Microsoft Learn
Regards,
Xiaoxin Sheng
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
73 | |
72 | |
71 | |
48 | |
45 |
User | Count |
---|---|
46 | |
38 | |
29 | |
28 | |
28 |