Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with burndown chart

Hi, I have this columns: 

 

 

and I want to get the "Result" column in order to put it in a line chart with the Days as X Axis

 

any ideas one which is the best DAX formula? 

 

Thanks,

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Cretae measures

    Measure = CALCULATE(SUM('Table'[points per day]),FILTER(ALLSELECTED('Table'),'Table'[days]<=MAX('Table'[days])-1))

Measure 2 = MAX([total points])-[Measure]

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous 

    Try like

    Result = [Total Point] -(sumx(filter(table,table[day]<earlier(table[day])),table[points per day])+0)

     

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    Cretae measures

    Measure = CALCULATE(SUM('Table'[points per day]),FILTER(ALLSELECTED('Table'),'Table'[days]<=MAX('Table'[days])-1))

Measure 2 = MAX([total points])-[Measure]

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.