Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
As a measure:
MyMeasure =
VAR ThisWeek =
MIN( 'Table'[Week] )
VAR PreviousWeek =
CALCULATE(
MAX( 'Table'[Week] ),
FILTER( ALLSELECTED( 'Table' ), 'Table'[Week] < ThisWeek )
)
VAR ThisSales =
MIN( 'Table'[Sales] )
VAR PreviousSales =
CALCULATE(
MIN( 'Table'[Sales] ),
FILTER( ALLSELECTED( 'Table' ), 'Table'[Week] = PreviousWeek )
)
RETURN
ThisSales - PreviousSalesRegards