Tag: Time Intelligence Function DAX

DAX Weekly Calculations – Power BI Time Intelligence Issues

Time Intelligence Issue of a DAX Weekly Calculations

In today’s tutorial, I’ll provide some techniques and tips on how to deal with common problems caused by DAX weekly granularity in time intelligence calculations. You can watch the full video of this tutorial at the bottom of this blog. I recently did a tutorial on obtaining Previous Week Values in Power BI. Since then,

Continue reading

Adding Time Intelligence To Customer Dashboards In Power BI


In this tutorial, you’ll learn how to make a customer dashboard more intuitive using time intelligence in Power BI. This is the second step when creating a customer deep dive dashboard. When creating visualizations, you’ll most likely have to compare different time periods. This could be a comparison between the cumulative sales for two simultaneous years. So, you need to start writing more complex

Continue reading

Time Intelligence DAX Functions In Power BI

For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX

Continue reading

How To Date Harvest In Power BI Using DAX

In this tutorial, we’ll go through date harvesting in Power BI to get information from a date slicer for a time intelligence analysis. You may watch the full video of this tutorial at the bottom of this blog. From previous tutorials, we’ve learned how to extend our date table while integrating a holiday table to

Continue reading

Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

Showcasing Growth Performance Effectively In Power BI - Advanced DAX

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. You may watch the full video of this tutorial

Continue reading