Getting the previous record values

Hi Anonymous ,

I create a table as you mentioned.

Then I think you can create a new table and here is the DAX code.

NewTable = 
SUMMARIZE (
    'Table',
    'Table'[StoreName],
    "Latest Score",
        CALCULATE (
            MAX ( 'Table'[Sum of TotalScore] ),
            'Table'[FormDate] = MAX ( 'Table'[FormDate] )
        ),
    "Previous Score",
        CALCULATE (
            MAX ( 'Table'[Sum of TotalScore] ),
            'Table'[FormDate]
                = MAXX (
                    FILTER (
                        'Table',
                        'Table'[StoreName] = EARLIER ( 'Table'[StoreName] )
                            && 'Table'[FormDate] < MAX ( 'Table'[FormDate] )
                    ),
                    'Table'[FormDate]
                )
        )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.