Running total for entire months but only showing data for 5 days?

[freakinaditya]

Hi all,

I have following data-

My requirements is to display last 5 days data and running total for entire months, when I put running total it is showing day wise 

something like this-

I want sale amount of that day and running total of entire month in last column of matrix (instead of total).

Can anyone help ?

Thanks in Advance!

[amitchandak · Accepted solution]

@freakinaditya , Try like

normal = if(max(Date[Day])>=26, [sales], blank())

Cumm = if(max(Date[Day])>=26,CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(day),date[day] <=maxx(date,date[day]))), blank())