Power BI Time Intelligence provides powerful functions to deal with Year, Quarter, and Month. But WTD and this Week vs Last Week do not have any out-of-the-box solution. Let’s quickly deal with Week Time Intelligence.

Power BI Time Intelligence functions provide a powerful way to get different types of time periods and time comparisons. Some of these are MTD, PMTD, PYMTD, MOM, MOYM, QTD, LQTD, QOQ, YTD, LYTD YOY etc. But dealing with a non-standard period can be a bit difficult, especially when months are not the standard months. In this article, we try to take on a case of non-standard periods (months).