Tag: Time Intelligence

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

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

Converting A YYWWD Code Into A Date Value In Power BI

How To Convert YYWWD Code Into Date Value In Power BI Query Editor Tutorial

In this blog, we will be discussing how to convert a YYWWD code into a Date Value. This tutorial was based on a response to a query of an Enterprise DNA Support Forum member. The member asked for a way to convert his Confirmed delivery date field, which is in a year, week, and day of

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