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

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.