Forum Discussion
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...
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
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,
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
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.