cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zaidel
Frequent Visitor

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

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

zaidel_0-1661201621877.png

 

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.

zaidel_1-1661202042909.png

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.

zaidel_2-1661202344562.png

Thanks in advance for your help!

Alex

2 REPLIES 2
parry2k
Super User
Super User

@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?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.