Standard time comparison has been made easy with the Power BI time intelligence function. However, there is always a need to compare data between two ranges. Let us explore how this can also be done easily.

This article explains how to create a Date Dimension Table in Power BI’s Query Editor with an additional set of columns that will allow you to sort report display columns in your Date Dimension, add conditional formatting capabilities, and last but not least, perform relative filtering on current ( 0 ), previous ( -1, -2… ) or future ( 1, 2... ) Date, Week or Month and many more.