Running Averages that can scale up and down Date Hierarchy

[Greg]

Hi @Swhs24. Perhaps the “Weekly Comparisons” section of this pattern post can provide a path some additional background:

Non-Standard Time Intelligence

The available DAX date intelligence functions in Power BI handle the comparison with previous periods easily for the standard periods of year, quarter, month, and day when using a standard calendar, or a standard fiscal calendar (where quarters start on a 3-month cadence, e.g., April 1, July 1, etc., and aligned to [but offset from] calendar quarters). These functions do not, however, handle weekly comparisons or custom fiscal calendars. Calculation techniques to handle week comparisons and non-…

Hope it helps.
Greg