Seperate value from running total measure based on max date

[Nagesh20]

Hi all,

I am able to calculat the running total based on max date. I would like to get final number from running total measure based on the max date. I have attached below example (i.e . Total value in table formate). I am looking for new Dax formuala to get this calucation 

Cumulative (running total measure) = 

IF([TotalValue]<>BLANK(),

CALCULATE([TotalValue],

FILTER(ALL(Calender[Date]),Calender[Date]<=MAX(Calender[Date]))))

Date	Product	Value	Cumulative	Totalvalue
5/2/2024 0:00	A	100	100
5/3/2024 0:00	A	50	150
5/4/2024 0:00	A	30	180
5/5/2024 0:00	A	26	206
5/6/2024 0:00	A	30	236	236
2/28/2023 0:00	B	50	50
3/1/2023 0:00	B	30	80
3/2/2023 0:00	B	26	106
5/6/2024 0:00	B	100	206	206

[amitchandak · Accepted solution]

@Nagesh20 ,  Create a measure using your measure

if(Max(Calendar[Date]) = maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date]) , [Cumulative (running total measure) ], blank()) 

or

Measure =
var _max =maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date])
return
Switch ( true(),
Max(Calendar[Date]) = _max , [Cumulative (running total measure) ],
Max(Calendar[Date]) < _max , 0 ,
blank())

[Nagesh20]

@amitchandak 

Awesome 🙂

2nd formula is working

Thanks a lot

[Nagesh20]

Hi @amitchandak 

I am not able to get the total when applying the second formula that you suggested. Could you please advice how to get the total for this formula in the table. 

Max =

Var _max=maxx(filter(allselected(Table1), Table1[Product] = max(Table1[Product]) ), Table1[Date])

return

Switch ( true(),

Max(Calender[Date]) = _max ,[Cumulative],

Max(Calender[Date]) < _max , 0 ,

blank())