How do I stop running total on the last value

Hi Sun4real  - Create a Measure for the Last Date with Data 

LastDateWithData =
CALCULATE(
MAX(Sales[Date]),
REMOVEFILTERS('DateTable')
)

I have taken the reference of Sales[Date], you can replace with the appropriate column from your dataset that contains the date of each transaction.

create main measure using the above lastdatewithdata with running totals

RunningTotal =
CALCULATE(
SUM(Sales[Amount]),
FILTER(
ALL('DateTable'),
'DateTable'[Date] <= MAX('DateTable'[Date])
&& 'DateTable'[Date] <= [LastDateWithData]
)
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!