Forum Discussion

icantwi's avatar
icantwi
Frequent Visitor
9 years ago

Burndown Chart for Milestones Tracking

Hi,

 

I'm hoping someone on here can help I am attempting to create a burndown chart similar to the attached screen shot within Power BI in order to track baselined finish dates against current finish dates. I have worked out that i will need to create a column within my milestones table that calculates the number of days between the finish date in a row and the latest finish date in the table which will then produce values that decrease the closer you get to the final finish dates. The problem is that i have no idea how to do this and i'm hoping someone here can give me a helping hand with the formula. I tried to use the DATEDIFF function to no avail. 

 

Thanks

Ian

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    I have worked out that i will need to create a column within my milestones table that calculates the number of days between the finish date in a row and the latest finish date in the table which will then produce values that decrease the closer you get to the final finish dates. The problem is that i have no idea how to do this and i'm hoping someone here can give me a helping hand with the formula.


    icantwi,

    Create the following columns in your table and check if you get desired result.

    LatestDateInTable = MAX(Table1[Finish])
    Number Of Days = DATEDIFF(Table1[Finish],Table1[LatestDateInTable],DAY)


    Regards,
    Lydia Zhang

    • icantwi's avatar
      icantwi
      Frequent Visitor
      9 years ago

      Thanks for this Anonymous, i am finding though that when i create the line chart from the data it's not quite working as expected. it comes up with the below.

       

      • icantwi's avatar
        icantwi
        Frequent Visitor
        9 years ago

        Sorry, a little further narrative is that it seems to sum the items that have the same month/date