Forum Discussion

AndreSatziack's avatar
AndreSatziack
Helper I
8 years ago
Solved

help with a simple burndown chart

Hello Team, I need to create a burndown line chart with sample data below. I tried use the follow dax code but don't worked for me, can you help me? Thank you very much.   BurnDown = 180 - CALCU...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    AndreSatziack,

    Create the following measures in your table and check if you get expected result.

    Burndown = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(), 3200 - CALCULATE(SUM(Relatorio_Anual_2017[Hours]),FILTER(ALL(Relatorio_Anual_2017),Relatorio_Anual_2017[Created]<=MAX(Relatorio_Anual_2017[Created]))))
    Burndown1 = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(),3200-CALCULATE([Total hours],DATESYTD('Calendar'[Date],"31/12")))



    Regards,
    Lydia

AndreSatziack's avatar
AndreSatziack
Helper I
8 years ago

Hello Ashish_Mathur,

 

My code "BurnDown = 180 - CALCULATE(SUM(Relatorio_Completo_2017[Hours]), FILTER(ALLSELECTED(Relatorio_Completo_2017[Criado]),ISONORAFTER(Relatorio_Completo_2017[Criado],MAX(Relatorio_Completo_2017[Criado]),DESC)))" only works for January and not for the rest of the months.

 

I need to use the last month result instead of 180 in the next months except January because the start with 180 hours to burn throughout the year.

 

This is a sample in Excel. I need to do this in Power Bi but I don't know how. Thank you very much :)

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi AndreSatziack,

 

You may download my solution from here.

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    AndreSatziack,

    Create the following measures in your table and check if you get expected result.

    Burndown = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(), 3200 - CALCULATE(SUM(Relatorio_Anual_2017[Hours]),FILTER(ALL(Relatorio_Anual_2017),Relatorio_Anual_2017[Created]<=MAX(Relatorio_Anual_2017[Created]))))
    Burndown1 = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(),3200-CALCULATE([Total hours],DATESYTD('Calendar'[Date],"31/12")))



    Regards,
    Lydia

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are most welcome AndreSatziack.  Share the link from where i can download the file where you have that case.

  • AndreSatziack's avatar
    AndreSatziack
    Helper I
    8 years ago

    Hello Ashish_Mathur,

     

    Thank you very much. I'm very grateful for your help. This solved my problem :) :)

     

    Can you help me one more last time? I need to filter the chart by created date, some customers starts the burndown in different dates. The chart always starts in January. I need it to start by created date filter.

     

    See the current status.

     

     

    Thank you very much.

  • AndreSatziack's avatar
    AndreSatziack
    Helper I
    8 years ago

    Hello Lydia Anonymous, Thank you very much again, your dax code bellow resolved my created date filter.

     

    Burndown1 = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(),3200-CALCULATE([Total hours],DATESYTD('Calendar'[Date],"31/12")))

     

    Best Regards.

  • AndreSatziack's avatar
    AndreSatziack
    Helper I
    8 years ago

    Hello Ashish_Mathur and Anonymous, Thank you very much for your help :)

     

    I'm very grateful for your help. You are the best! :)

     

    Best Regards Team!

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Non of these work for me. I am pulling history in VSTS. This is summation of Remaining work by Changed Date and Is Current flag.

    Please help me with this burndown chart.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    None of these work for me. I am pulling history in VSTS. This is summation of Remaining work by Changed Date and Is Current flag.

    Please help me with this burndown chart.