Help with burndown chart

[Anonymous]

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,

[v-juanli-msft · Accepted solution]

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.

[amitchandak]

@Anonymous 

Try like

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