Same Period Last Year for Fiscal Week Nbr (weeks in sales table are non standard)

DAX DAX Calculations
2

Hi there,

Yes as you’ve seen unfortunately time intelligence calculations don’t work for fiscal weeks.

Here’s are some videos that talk through how to solve this.

This is the ultimate formula you would need

Previous Year Sales = 
VAR CurrentMonth = SELECTEDVALUE( Dates[Week Number] )
VAR CurrentYear = SELECTEDVALUE( Dates[Year] )

RETURN
CALCULATE( [Total Sales],
    FILTER( ALL( Dates ),
		Dates[Week Number] = CurrentMonth && Dates[Year] = CurrentYear - 1))
1 Like