Forum Discussion

AndreSatziack's avatar
AndreSatziack
Icon for Helper I rankHelper 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

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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
Icon for Helper I rankHelper 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
    Icon for Super User rankSuper 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.