Burndown Chart Help Needed with Measures

[elly2212]

Hi, I am trying to build burndown chart visual for multipel projects with different Start and Completion date. Some sample data below. Can you please assist with measures in order to build a final Burndown Table with the Remaining values to use in visual? Thanks!! 

Product	Project Start	Target Completion	Total Instances	Completed	As Of
P1	9/1/2023	6/30/2024	40,000	10,000	11/30/2023
P2	11/1/2023	6/30/2025	5,000	1,000	11/30/2023

[aj1973 · Accepted solution]

Hi @elly2212 

check out this

https://community.fabric.microsoft.com/t5/Desktop/Burndown/m-p/1196014

[Ashish_Mathur]

Hi,

Please show the expected result in a simple Table format.

[elly2212]

Targeting the yellow summary of this image: 

[Ashish_Mathur]

Hi,

Share the download link of the MS Excel file with the formulas already written there.  I will try to convert those Excel formulas into measures using DAX.

[elly2212]

Please try this link: Example Excel 

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[elly2212]

Thanks for your assistance! This is where I am so far and looking to add Running (but Remaining/decreasing) Totals. I looked at the link but cannot relate tbh.  

[aj1973]

@elly2212 

Why do you want to create calculated columns? Not good and won't work

Use calculated measures to running total then... Follow thread I sent you 

[aj1973 · Accepted solution]

Hi @elly2212 

check out this

https://community.fabric.microsoft.com/t5/Desktop/Burndown/m-p/1196014