How to Compare Two Time Periods or Dates Dynamically in Power BI (P1: Years)

In this video, we are going to see how to compare two time periods or two dates dynamically. We will create year and relative year dimensions. What are active and inactive relationships? And how to call an inactive relationship in a DAX measure and use it in the report. We will use VALUES, CALCULATE, USERELATIONSHIP and ALL dax functions. As a bonus, we will also see how to use specific measures for conditional formatting.