Week over Week Percentage %

DAX DAX Calculations
4

Hi @Mike,

Based on how you wrote your measures I assumed the ‘Date’[LastFiscalWeekX] is dynamic. If that is not the case check out the M code in this topic on how to create offsets in your Date table.

WoW Ch % = 
VAR vTable = FILTER( SUMMARIZE('Date', 'Date'[Weekday], 'Date'[LastFiscalWeekX] ),'Date'[LastFiscalWeekX] IN {0, 1} )
VAR nTable = ADDCOLUMNS( vTable, "@LW", [Last Week Sales], "@TW", [This Week Sales] )
RETURN

DIVIDE(
    SUMX( FILTER( nTable, 'Date'[LastFiscalWeekX] = 0), [@TW] ),
    SUMX( FILTER( nTable, 'Date'[LastFiscalWeekX] = 1 && [@TW] <> BLANK()), [@LW] )
)

with this result
image

1 Like