Forum Discussion
Calculate Measure1 as Measure2 + Measure3 Running Total
- 2 years ago
Click here to download the solution
How it works ...
Create a Calandar tableCreate a measure
YTD cumulative = VAR myyear = SELECTEDVALUE('Calendar'[Year]) VAR myperiod = MAX('Calendar'[Date]) RETURN CALCULATE( SUM(Facts[Amount in company currency]), ALL('Calendar'), 'Calendar'[Year] = myyear && 'Calendar'[Date] <= myperiod )Dsiplay in matrix
Thanks for the clear description of the problem with example data. I wish everyone did that!
Remember we are unpaid volunteers. So please click the thumbs up and the [accept as solution] button to leave kudos.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
Please now click the thumbs up and the [accept as solution] button. Thnak you.
Is 2026 a typing mistake ?
speedramps , no everthing apart from amounts have been downloaded as is. I noticed the break in timeline, but it's fine. The idea is to redistribute the running total amount to the very next time period, with each month.
- speedramps2 years agoSuper User
See solution I provided