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,
In this tutorial, I want to show you what the CALCULATE function can do through a few examples. CALCULATE is one of the most frequently used functions in Power BI. It dictates the context being applied to any measure and removes any existing filters in place. Using CALCULATE Function For Total Sales To truly understand
I’m going to talk about the solution I came up with for the 7th Problem of the Week. The problem required a dynamic report that uses multiple DAX calculation groups. You can watch the full video of this tutorial at the bottom of this blog. The Problem of the Week happens every 1st and 3rd
In this tutorial, I’m going to talk about Power BI financial year to date calculations. Achieving a year to date analysis of a selected period is quite complex, but I’ll demonstrate to you a formula technique that enables you to quickly create a cumulative total over your specific financial year. You can watch the full
In this tutorial, I’m going to cover the best time intelligence function, the Power BI DATEADD. It’s one of the time intelligence functions that you should introduce yourself to as soon as possible when learning Power BI. You may watch the full video of this tutorial at the bottom of this blog. The Power BI
