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.
Click here to download the solution
How it works ...
Create a Calandar table
Create 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.