Need to calculate the difference between a year vs previous chosen year (or given date or month)

[zaidel]

Hello Community, this is my first question I hope you can help me; please see below.

This is a very easy function within Excel pivoting. Adding a field that will calculate the margin of grouth between a given year and the previous one (the previous chosen). It is called "show value as percentage difference from Previous". See screen capture from excel below.

I tried to add the sales field again and explore the Show Value options, but none of them get close to what I am looking for.

Thanks in advance for your help!

Alex

[parry2k]

@zaidel do you have a calendar dimension in your model? That is the starting point when you are working with time intelligence in Power BI?

[zaidel]

Thanks for your quick reply.

I do have a calendar table. Keep in mind the goal is not to be able to calculate 2022 sales vs 2021, but from a chosen year vs another chosen year (and could be more than 2). Same applies to month or specific dates.