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.
Tag: Time Intelligence Calculations
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
In this tutorial, I’ll show you a dynamic way of getting the Percent of Total Change in Power BI using simple measure branching techniques and time intelligence calculations in Power BI. For example, if you want to work out the difference in contribution of Sales for a particular dimension and its change from year to
This is a very unique example of Time Intelligence in Power BI, especially when working with workdays and weekends. This tutorial came ftom a request from the Enterprise DNA Support Forum, where a member needed to get the day for each weekday and the day of each weekend into their Date table. I’ve seen this
Let’s really go deep into DAX formula with the Power BI PARALLELPERIOD function. We’ll look into this amazing DAX function and see how to use this in quite an effective way inside some calculations. You might also find some other usages different to what I’m going to demonstrate in this DAX function review. I’m going