Category: Time Intelligence

Adding Workday And Weekend Numbers Into Your Date Table: Time Intelligence Technique In Power BI

This is a very unique example of Time Intelligence in Power BI, especially when working with workdays and weekends. This tutorial came ftom a request from the Enterprise DNA Support Forum, where a member needed to get the day for each weekday and the day of each weekend into their Date table. I’ve seen this

Continue reading

Showing The Last Three Customer Sales Using The TOPN Function

I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. What I want to show you is how to work out the sales from a specific customer, but by only

Continue reading

Showing Results Before Or After A Selected Date Using DAX

Showing Results Before Or After A Selected Date Using DAX

As we work through this tutorial, I will show you some truly powerful analytics that you can complete inside of Power BI. What we are attempting to analyze here is the information around a selected date. We are going to look at a specific time frame , and then look at a range of days

Continue reading

Data Normalization in Power BI for Different Days Results

Normalizing Results On Different Days - Time Related Analysis In Power BI Using DAX

This tutorial stems from another question on the Enterprise DNA Forum about data normalization. The techniques that I will teach you will be important in getting rid of anomalies that can possibly make things complicated during the data analysis. Occasionally, when running analysis in Power BI, you may need to take into account the sales

Continue reading

Show Results Up To Current Date Or A Specific Date In Power BI

In this tutorial, I’ll show you a very specific technique where you can show data or filter up to the current date (today) or any specific date in your Power BI reports. I’ve seen this asked a few times, especially on the Enterprise DNA Support Forum. I’ve personally used this technique many times, so I

Continue reading