Forum Discussion
New Time Intelligence Calculation Group (Model explorer) PY YTD
Hi all,
I applied the new feature Time Intelligence calculation group from the Model view.
I calculate YTD:
YTD =
CALCULATE(
SELECTEDMEASURE(),
DATESYTD(DimDates[Date])
)
How do I write YTD for the previous year please ?
Year-1 YTD =
CALCULATE (
SELECTEDMEASURE (),
SAMEPERIODLASTYEAR ( DimDates[Date] ),
'Time Intelligence'[Show as] = "YTD"
)
I have scoured the web looking for an answer on this topic and I tried different solutions, with no success. (I found examples for time intelligence measures, which do not meet the need.)
https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Usually Previous Year is calculated:
YearAgo = CALCULATE([Measure YTD], DATEADD(DimDates[Date], -1, YEAR))
but in this case we don’t specify the measure, we use selectedmeasure ()
how do we “translate” 'Time Intelligence'[Show as] = "YTD".
Any help would be much appreciated.
Thank you.
Hi AH2022 from the link Deep dive ...
exact order of steps should be followed to correctly create this measure (PY YTD)
Did you create Calculated group column and renamed it to Show as, check picture, part on the link?