Tag: Offsets

Time Intelligence In DAX: How To Dynamically Select Starting Period

By Brian Julius, Enterprise DNA Expert on April 13, 2022November 8, 2022

Power BI Dynamically Select Starting Period

In this blog post, we will deal with some troublesome issues in time intelligence, particularly those issues caused by week granularity and the troubles that can be caused by the irregular number of weeks in a year. We’ll use offsets to come up with accurate time intelligence in DAX. We have an interesting scenario for

Posted in: CALCULATE function, Date Table, MAX function DAX Power BI, MIN function, Offsets, Time Intelligence

Power BI

Using The Offset Function In Extended Date Tables

By Melissa de Korte, Enterprise DNA Expert on September 27, 2020October 11, 2022

I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.

Posted in: Date Table, Date Table Power BI, Extended Date Table, Offset Function, Offsets, Time Intelligence, Time Intelligence Calculations, Time Intelligence Power BI