Return Amount from same day last week and another filter

[Anonymous]

I want to be able to get the amount for same day last week from the same store per row, below is a simple illustration. Note: The report I am creating is on import mode. Would appreciate your response!

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

For your desired output, please try the measure below.

Measure =
VAR max_ =
    MAX ( 'Data'[Date] )
RETURN
    CALCULATE (
        MAX ( 'Data'[Amount] ),
        FILTER (
            ALL ( 'Data' ),
            'Data'[Store] = MAX ( 'Data'[Store] )
                && 'Data'[Date] = max_ - 7
        )
    )

Here is the output.

Hope this can help you!

Best  Regards,

Cherry