Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Jos_Woolley
Solution Sage

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 - PreviousSales

Regards