Need get running total for every day

[Anonymous]

Hi,

I have below columns in Power BI table. I need to show the running total for every day in the table how to show everyday total. 

Please help me on this.

Thanks,

Raj

[Anonymous · Accepted solution]

@Anonymous 

This dax is the running total formula for a calculate column. Dax for measure:

Measure = Sumx(filter(allselected(Table), [lastenrollon] = max( [lastenrollon]) && [Index] <=max([Index])), [valuecolumn])
Or 

Measure = Calculate(sum([valuecolumn]), filter(allselected(allselected(Table), [lastenrollon] = max( [lastenrollon]) && [Index] <=max([Index])),

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Anonymous 

you can try

Measure = CALCULATE(sum('Table'[value]),FILTER(all('Table'),'Table'[date]<=max('Table'[date])))

pls see the attachment below

[amitchandak]

@Anonymous , As you do not have timestamp in date you need index for running total column

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

countx(filter(Table, [lastenrollon] = earlier( [lastenrollon]) && [Index] <=earlier([Index])), [lastenrollon])

daily total

countx(filter(Table, [lastenrollon] = earlier( [lastenrollon]) && [Index] <=earlier([Index])), [lastenrollon])

use sumx for value columns 

[Anonymous]

Hi,

I created Index Column and named as SNO  and tried doing your query mentioned above. the above is not executing. 

Please help on this.

Thanks,

Rajesh