Calculating Latest Weeks & Comparing to Same Timeframe PY

Hi L1102 ,

Use a proper Calendar table

Relationship:

Calendar[Date] > Data_Dump_Sheet[Week End]
No relationship from Latest Time Periods > fact table, it must remain disconnected.

Base measure
[Sales] = SUM ( Data_Dump_Sheet[$ Sales] )

Current Period which is dynamic
Sales_Selected Period =
VAR SelectedDates =
CALCULATETABLE (
VALUES ( 'Calendar'[Date] ),
TREATAS (
VALUES ( 'Latest Time Periods'[Date] ),
'Calendar'[Date]
))
RETURN
CALCULATE ( [Sales], SelectedDates )

This applies L4 / L12 / L52 / YTD dynamically.

Prior Year with same timeframe

Sales_Selected Period PY =
VAR SelectedDates =
CALCULATETABLE (
VALUES ( 'Calendar'[Date] ),
TREATAS (
VALUES ( 'Latest Time Periods'[Date] ),
'Calendar'[Date]
))
VAR PYDates =
DATEADD ( SelectedDates, -1, YEAR )
RETURN
CALCULATE ( [Sales], PYDates )

Variance measures:

Sales_1 = [Sales_Selected Period] - [Sales_Selected Period PY]

Sales_%_1 = DIVIDE ( [Sales_1], [Sales_Selected Period PY] )

Hope this helps.
Thank you.