Tag: Power BI Custom Calendars

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

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

Power BI Custom Calendars: Calculating For Month On Month Change – 445 Calendars

This tutorial is about how you can run time intelligence calculations over custom calendars in Power BI. This is really relevant to those who deal with 445 calendars, which is a very common scenario for Power BI users. Not all businesses out there work to a standard calendar around financial years or calendar years. Sometimes

Continue reading