Tag: Time Intelligence Calculations

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

Calculating Dynamic Percentage Of Total Change Using Power BI Time Intelligence

Calculating Dynamic % Of Total Change – Power BI Analysis With DAX

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

Continue reading

Adding Workday And Weekend Numbers Into Your Date Table: Time Intelligence Technique In Power BI

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

Continue reading

DAX Function Review: Using PARALLELPERIOD In Power BI

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

Continue reading