Category: Time Intelligence

Using The ALL Function In Power BI For High Quality Insights

This blog post will show you how to use the ALL function in Power BI to effectively showcase unique insights and differentials in your numbers. We’re going to dive into the average order size for the sales we may be making across a variety of different products. This tutorial will also show you how to

Continue reading

Compare Cumulative Information Over Different Months In Power BI

Showcasing cumulative results in Power BI is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When

Continue reading

The DATEADD Function: The Best And Most Versatile Time Intelligence Function in Power BI

If you need a Power BI time intelligence function that you can use to generate time comparisons over a range of different time frames, then the DATEADD function is the one you’re looking for. This, by far, is my go-to time intelligence function in DAX at the moment. After going through this post and the

Continue reading

How To Work With Multiple Dates In Power BI

As soon as you start developing a few Power BI models, you’ll very likely run into a problem where you have two dates in your fact table and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date, invoiced date, shipped

Continue reading

Last Purchase Date in Power BI: When Did Your Customers Make Their Last Purchase?

It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success. One way to do this is by knowing your customers’ last purchase date in Power BI. In this blog post, I am going to demonstrate

Continue reading