How to "Sumif" From the same Table in DAX

[GooseHelpful199]

I have historical sales data that I want to create a "Last Week Sales" column for. I was able to add a "Last Week" column successfully, and am trying to get the Last Week Sales column to work correctly, which needs to be a "Sumif" type of formula that works within its own table. LOOKUPVALUE isnt an option here since there will be multiple results per week.

Any advice on how I can get this column to work? I tried using the below, but I can only get this type of formula to work if the data is on another table.

Last Week Sales = SUMX(FILTER(GRS, GRS[Week]=GRS[Last Week]),GRS[Sales])

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

EARLIER function (DAX) - DAX | Microsoft Learn

Last week sales CC =
SUMX ( FILTER ( GRS, GRS[Week] = EARLIER ( GRS[Last Week] ) ), GRS[Sales] )