Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
AppleUSN
Frequent Visitor

Burn Down Chart By Due Date with Conditions

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.

 

 

 

Part Description
Contract DateDock Date
HARNESS ASSEMBLY, ENGINE CONTROL3/8/20234/6/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/8/20234/6/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/10/20235/11/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/10/20235/11/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/10/20235/11/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/31/20236/2/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/31/20236/2/2023
HARNESS ASSEMBLY, ENGINE CONTROL3/31/20236/2/2023
HARNESS ASSEMBLY, ENGINE CONTROL4/10/20234/10/2023
HARNESS ASSEMBLY, ENGINE CONTROL4/10/20234/10/2023

 

Date (MM/DD)3/27/234/3/234/10/234/17/234/24/235/1/235/8/235/15/235/22/235/29/236/5/236/12/236/19/23
Actual count of overdue and future overdue
 
8            
Forecast count of overdue lines
 
 666663330000
3 REPLIES 3
Anonymous
Not applicable

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.

Before You Post, Read This 

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.

 

Planned Delivery =
VAR _count =
    CALCULATE (
        COUNT ( 'PWA OOR'[Past Dues] ),
        FILTER ( ALL( 'Date' ), 'Date'[Date] > MAX( 'Date'[Date] ) ),
        USERELATIONSHIP ( 'Date'[Date], 'PWA OOR'[On Dock Date] )
    ) + 0
VAR _date =
    CALCULATE (
        SELECTEDVALUE ( 'PWA OOR'[On Dock Date] ),
        USERELATIONSHIP ( 'Date'[Date], 'PWA OOR'[On Dock Date] )
    )
RETURN
_count
 
First, I am still trying to learn the DAX code so I can understand what it is doing on each line.  Sometimes I can see it but sometimes I cannot.  In this case above I had to change MIN to MAX and the RETURN _Count was also different.  It was removing the values before I changed it.  I appreciate you reaching out and giving more blogs to read though.  Most of it I have incorporated already but that was a lot of information in one spot.
Anonymous
Not applicable

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

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.