The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have running total which doing as expected but I'm unable to stop it a the last value date instead it going on forever till end of date calendar.
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 !!
Proud to be a Super User! | |
The result is still the same. I've attached the pbix to make it easier