dax help

Hi sarath_chandra ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
VAR cur_date =
    SELECTEDVALUE ( 'Table'[Date] )
VAR cur_val =
    SELECTEDVALUE ( 'Table'[Field Value] )
VAR cur_st =
    SELECTEDVALUE ( 'Table'[Setup] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Setup] = cur_st && 'Table'[Date] < cur_date )
VAR pre_date =
    MAXX ( tmp, [Date] )
VAR pre_val =
    CALCULATE (
        MAX ( 'Table'[Field Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Date] = pre_date && 'Table'[Setup] = cur_st )
    )
RETURN
    IF ( DAY ( cur_date ) = 1, 0, ABS ( cur_val - pre_val ) )

3. add a table visual with fields and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.