Calculate Relative Weeks in Power BI
Time Intelligence has always been an interesting topic while implementing any Microsoft Business Intelligence (BI) project. May it be from a big enterprise scale to a small Power BI project. Analyzing data over a period helps us understand how the rate of a specific subject has changed in presence of other factors. For example, Year over Year (YoY) or Month to Date (MTD), all these calculations are easily available in DAX for year, month and quarters. However, when it comes to weeks, there is no out of the box formula to compare week values directly.