Tag: Time Intelligence Power BI

Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables

I’ll show you how to set up dynamic start and end dates when you’re using power query date tables. If you’ve been following this series on different Time Intelligence subjects, you already know how to create a date table using power query functions. You might have also read about how to change the end date

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

Show Changes Over Time In Power BI Reports

In this Power BI Showcase, we’re going to focus on time intelligence in Power BI to showcase how our business metric changes over time. We have a reseller of a product that’s being sold throughout the East Coast of Australia. We want to analyze all their key metrics which includes Sale and Profits among other

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

Creating A Calendar Table For Holidays In Power BI

This tutorial will address a common time intelligence issue about creating a Power BI calendar table with only holidays. For time intelligence, the creation of a holiday table is a weird topic to start but it is one of the essential requirements to extend the standard date table. There are three ways to make a

Continue reading