I have 2 tables, a date table that consists of the following fields:date, year, yearmonth, month, day, WeekNum The second table Consists of the following fields: Name, Cost, Date. The tables are linked by the date measure. I want a dax measure that can give me week over week change in cost. I already have a month over month change in cost measure but the same logic can't be applied here because "dateadd" does not give me "Week addition".
Week over Week calculation gives me wrong results.
Week Over Week = CALCULATE( SUM ( UsageDetails[Cost] ) - CALCULATE ( SUM ( UsageDetails[Cost] ), FILTER ( ALL ('Date' ), 'Date'[Year] = YEAR( NOW() ) && 'Date'[Week Number] = MAX ( 'Date'[Week Number] ) - 1 && 'Date'[Week Day] = MAX ( 'Date'[Week Day] ) ) ))