Create Year-Over-Year Calculations in Power BI (DAX Guide)

In this video, we explain how to create year-over-year calculations in Power BI using DAX coding.

Go Analytics is a data analysis and visualization consulting firm specializing in Microsoft Power BI. For any Power BI inquiries, please contact us at https://goanalyticsbi.com/contact.

You can download our template files here: https://goanalyticsbi.com/lead-magnet-download-form-youtube/

In this video, we explore the world of time-intelligence calculations in Power BI using DAX coding.

Through an example, we explain how use the CALCULATE, DATEADD, and SAMEPERIODLASTYEAR functions in Power BI's DAX programming language. We start by changing the filter context for our existing measure, so that we obtain our measure for last year (under the current filter context). We then use the growth rate (or year-over-year) formula to create a percentage change year-over-year. In doing so, we also learn how to use DAX's DIVIDE function in Power BI.

Hope you enjoy this video and we'll see you in the next one!

For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.

About Go Analytics Inc.

We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.

Need help getting started with Power BI? Let's connect!
Visit our website at https://goanalyticsbi.com
Follow us on Twitter at https://www.twitter.com/GoAnalyticsInc
Connect with us on LinkedIn at https://www.linkedin.com/company/go-analytics-inc

***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.