How to Calculate Sales Difference by Year with Power BI?
Let's say we want to calculate the difference between this year's sales and last year's sales using Power BI. There are a few steps we need to follow.
The first step is to decide what the first measure we'll create will be. For this calculation, we first need to calculate total sales.
Let's make a note here. You can write quite complex time intelligence formulas, but my advice is to always start simple and work your way through step-by-step. Start with simple measures, as we did here, and then start using time intelligence formulas.
Now, next, we need to calculate last year's total sales. The formula we'll write will go to last year's date, look at the previous year's sales corresponding to that date, and calculate last year's sales.
In this video, we'll learn by applying the SAMEPERIODLASTYEAR function, one of my most frequently used time intelligence formulas.
If you want to collate data and create professional-quality Business Intelligence Reports from start to finish, join the 2-in-1 Premium Power BI Online Training, updated with the DAX Workshop, now at: https://www.udemy.com/course/microsof...
To join the Premium Power BI Online Training at a discount, use the coupon code: HAZIRANOZEL35TL
Don't forget to subscribe to the channel for new educational content and Power BI tips updated weekly.
https://rebrand.ly/msozkta
****Things You Need to Know About Power BI****
1- What is Power BI?: / power-bi-nedir
2- What are the Advantages of Power BI as a Business Intelligence Tool? https://rebrand.ly/ma6fcc
3-Why Use Power BI When You Can Use Excel? https://rebrand.ly/9iuan3
4-CALCULATE: Meet the Most Popular DAX Formula!: https://rebrand.ly/7gm8ex
5-1, 2, 3, 4, and Big Data with Power BI: https://rebrand.ly/fy9yiq
6-What is a Filter Context in Power BI? https://rebrand.ly/2awz2w
#DAXApplications #PowerBI #PowerBITraining