In this article, I am going to talk about time intelligence functions in Power BI. We have already touched on a previous example with the fields Date, Total Sales, and Sales Last Year. As you can see, there is no data in Sales LY prior to 2019. In the DAX Formulas Reference Guide, you can
Tag: Time Intelligence
For this tutorial, I’m going to cover some high-quality time-related insights directly from your supply chain metrics. You may watch the full video of this tutorial at the bottom of this blog. This is connected to a tutorial I previously conducted about supply chain management. It involves a technique on managing a particular operational scenario
The Power BI running total is the perfect way to display patterns and changes on a specified data over time. In Power BI, there is a common combination of DAX functions that allow us to create a dynamic cumulative total (sum) on any report page. The DAX formula that we’re about to discuss is easy
If you want to have a real-world example scenario of forecasting using Power BI, you’re in the right page. You’ll find in this tutorial a forecasting technique that you can surely implement in your own work environment. You may watch the full video of this tutorial at the bottom of this blog. In the example,
When analyzing actual results in your data, you may sometimes want to compare it to a forecast or run rate. In this tutorial, I’ll show you how to calculate a cumulative run rate based on some historical results. You may watch the full video of this tutorial at the bottom of this blog. This came out