Tag: Time Intelligence Power BI

Get Power BI Previous Week Values Using DAX & Power Query

Retrieving previous period values in Power BI is a common task, but retrieving previous week values requires some special attention. In this tutorial, I’ll discuss two straightforward and versatile methods for obtaining Power BI’s previous week values that can be useful additions to your toolbox – one using DAX and the other using Power Query.

Continue reading

Time Comparisons In Power BI: This Year vs Last Year

Time Comparisons In Power BI: This Year vs Last Year

I want to go over how you can easily do time comparisons in Power BI and specifically calculate this year versus last year. I’m going to show you a couple of techniques that you can utilize for time comparisons like this. You can watch the full video of this tutorial at the bottom of this

Continue reading

Compare Data Points From Different Timeframes In One Visualization – Power BI

Compare Data Points From Different Timeframes In One Visualization - Power BI

In this blog I’ll show you how you can compare data from different timeframes within the same visualization. You can get amazing Power BI insights using this great technique with time-related DAX. You may watch the full video of this tutorial at the bottom of this blog. I discovered this approach from the Enterprise DNA

Continue reading

DAX MAXX Function In Power BI – Discover Last Date

I’m going to share a quick and efficient formula around the DAX MAXX function in Power BI. In this example calculation, I’ll show you how to find the last date something occurred using MAXX, which is an iterating function. You may watch the full video of this tutorial at the bottom of this blog. I’ve

Continue reading

Adding Time Intelligence To Customer Dashboards In Power BI

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