Tag: Time Intelligence Calculations

Using The Offset Function In Extended Date Tables

Using The Extended Date Table - OFFSETS In Power BI

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.

Continue reading

Using IsAfterToday for Power BI Time Intelligence Scenarios

Using The Extended Date Table - ISAFTERTODAY

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

Continue reading

Common Time Intelligence Patterns Used In Power BI

Common Time Intelligence Patterns Used In Power BI

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,

Continue reading

Year To Date Sales For Power BI Custom Calendar Tables

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.

Continue reading

Create Dynamic CRM Forecast From Today Until End Of Month

Calculate Total CRM Forecasts From Today Until End Of Month

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

Continue reading