RUNNING TOTAL **bleep** DISPLAY ONLY RECENT DATE

[jamc]

Hi im looking a dax tha only allows me to calculate running total for the most recent date available, (without displaying previouse date), I managed to get the running total but I need only to display the cummulative view in one row (which will chang every time that I changed the dates parameters)

Date	Dmd Total	**bleep** Dmd Total	Desirable outcome
1/30/2023 0:00	0	0
2/6/2023 0:00	0	0
2/13/2023 0:00	777	777
2/20/2023 0:00	687	1464
2/27/2023 0:00	340	1804
3/6/2023 0:00	0	1804
3/13/2023 0:00	0	1804
3/20/2023 0:00	0	1804	1804

[tamerj1]

Hi @jamc 

please try

=
IF (
SELECTEDVALUE ( [Date] ) = MAXX ( ALLSELECTED ( [Date] ), [Date] ),
[Running Dmd Total]
)