I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.
I’m going to show you how to use IsAfterToday in extended date tables for Power BI time intelligence scenarios. When it comes to DAX functions and other tools, I assign them certain jobs or personas in my head so that I can easily remember what they do. For example, I see SWITCH as an air
I want to do a quick run through of time intelligence patterns commonly used in Power BI. This is covered in detail in the Mastering DAX Calculations course at Enterprise DNA online. In the course, there are in-depth discussions on how to use these functions and get better insights using time-related data. But for now,
We’re going to dive into some custom Power BI calendar tables in this tutorial. Many organizations don’t work by the standard calendar date – they might work by a financial week number or by a custom week number. However, the time intelligence calculations in Power BI just don’t work with these custom or non-standard calendars.
In this tutorial, I’m going to show you how to create a dynamic total CRM forecast within a specified date range. Let’s say for example, you want to find out the forecast in a particular month. You want to know how many forecasts there are for the rest of the month from today until the
