Normalizing Results On Different Days In Power BI Using DAX

Normalizing Results On Different Days In Power BI Using DAX

One comment

Occasionally when running analysis in Power BI, you may need to take into account weekends or public holidays where there is no data.

When there is no data, it can make your visualizations look a little bit off.

That’s where this normalizing technique comes into play…where you might need to normalize, for example, sales amounts across a public holiday or across a weekend.

This is quite a unique example of time intelligence techniques in Power BI.

A very useful one though, if you are dealing with a specific scenario around limited data or no data appearing in your raw information.

I go through a number of different DAX functions within this tutorial. We work with the SUMMARIZE function, other table functions and also some simple filters with the CALCULATE function.

We are able to effectively manage across different timeframes with these particular functions.

A lot of useful techniques all combined here that will enable you to run some unique time-related pieces of analysis inside Power BI.

If you want to check out more around a variety of different time intelligence techniques inside of Power BI, I recommend having a look at our course module inside of Enterprise DNA online which specifically caters to this types of analysis.

Time Intelligence Calculations

Enjoy working through this detailed video.

Sam

 

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

 

***Learn more about Enterprise DNA Membership***membership banner 3

1 comments on “Normalizing Results On Different Days In Power BI Using DAX”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.