Calculating the difference between weekly sales results in Power BI is unfortunately not that easy.
The reason behind this is that Power BI doesn’t have a weekly based, built-in time intelligence function. The only available options are for the day, month, quarter, and year.
Therefore, to be able to work out weekly results in Power BI, we need to utilize different logic within a formula. It’s unfortunately slightly more advanced, but it’s an important and really high-quality technique that you need to understand and utilize in your models.
If you can understand some of the formula techniques that I work through to actually calculate this result, then you’re doing very well with DAX inside of Power BI. Invariably you will be able to create some really good insights and high quality analysis in your Power BI reports.
In this video tutorial, I run through how to use the CALCULATE and FILTER functions, including how to utilize variables really effectively within your DAX formulas.
It is a really great concept to understand as it will provide you with good insights, especially if you’re working with information over weeks.
Maybe you’re a retailer and you want to analyze this week versus last week, or this week during this month versus the same week the year before.
The tutorial will show you how such great analysis can be done if you utilize these formula techniques in combination with your data models.
For much more on data modeling in Power BI, certainly check out the Advanced Data Transformations & Modeling at Enterprise DNA Online. The feedback I get from this one module is crazy, so well worth reviewing.
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online