Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi.
I don't know how to create a measure to compare this year with 2 years ago.
To compare with last year I have used SAMEPERIODLASTYEAR and it works well.
Tks.
Daniel Kataoka.
Solved! Go to Solution.
Hi @Anonymous
You can use parallelperiod function and a calendar table...
Last two years prior =
CALCULATE (
SUM ( Table[column_name] ),
PARALLELPERIOD ( 'Calendar'[Date], -24, MONTH )
Hope this helps!
Thanks,
AnthonyJoseph
Hi @Anonymous
You can use parallelperiod function and a calendar table...
Last two years prior =
CALCULATE (
SUM ( Table[column_name] ),
PARALLELPERIOD ( 'Calendar'[Date], -24, MONTH )
Hope this helps!
Thanks,
AnthonyJoseph
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
36 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |