Tag: Time Intelligence Function DAX

Time Intelligence DAX Functions In Power BI

For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX

Continue reading

How To Date Harvest In Power BI Using DAX

In this tutorial, we’ll go through date harvesting in Power BI to get information from a date slicer for a time intelligence analysis. From previous tutorials, we’ve learned how to extend our date table while integrating a holiday table to it. Now, we need to harvest dates from the data slicer to start using our

Continue reading

Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

Showcasing Growth Performance Effectively In Power BI - Advanced DAX

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. The technique that I’m going to go through can

Continue reading

Dynamically compare current totals to last years totals

Latest post out on the Power BI blog out now! Comparing totals this year to last year is a pattern you will use many times over with Power BI. It is always a good benchmark when looking to analyse how a certain metric is performing in the business. Click here to jump over to the

Continue reading