Forum Discussion
Solved
Week over Week Change
Good Afternoon,
Like many others, I am having issues getting my Week over Week Change to work properly. Have watched numerous videos, but have now turned myself into knots. So reaching out to ge...
not pretty but should work
previousWeek = var maxdt = MAX( dates[Date] ) var maxdtPerWeek = CALCULATETABLE( ADDCOLUMNS( SUMMARIZE( dates, dates[Week No] ) ,"@MaxDate", CALCULATE( MAX( dates[Date] ) ) ), REMOVEFILTERS( dates ) ,dates[Date] <= maxdt ) var prevWeek = INDEX( 2, maxdtPerWeek ,ORDERBY( [@MaxDate], desc ) ) var prevWeekDate = SELECTCOLUMNS( prevWeek ,"@date", [@MaxDate] ) RETURN CALCULATE( SUM( 'Table'[balance] ), TREATAS( prevWeekDate, dates[Date] ) )
not pretty but should work
previousWeek =
var maxdt = MAX( dates[Date] )
var maxdtPerWeek =
CALCULATETABLE(
ADDCOLUMNS(
SUMMARIZE( dates, dates[Week No] )
,"@MaxDate", CALCULATE( MAX( dates[Date] ) )
),
REMOVEFILTERS( dates )
,dates[Date] <= maxdt
)
var prevWeek =
INDEX(
2,
maxdtPerWeek
,ORDERBY( [@MaxDate], desc )
)
var prevWeekDate =
SELECTCOLUMNS(
prevWeek
,"@date", [@MaxDate]
)
RETURN
CALCULATE(
SUM( 'Table'[balance] ),
TREATAS( prevWeekDate, dates[Date] )
)
