Price inflation MoM and accumulated

[Anonymous]

Hi, 

I have months and average competitor prices per month, how can I calculate inflation, per month and accumulated, September to be a base month with 100 Index?

Thanks

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, here's my solution. Create two calculated columns.

MoM =
VAR _Pre =
    MAXX (
        FILTER (
            'Table',
            EOMONTH ( 'Table'[Wave], 0 ) = EOMONTH ( EARLIER ( 'Table'[Wave] ), -1 )
        ),
        'Table'[avg reg]
    )
RETURN
    DIVIDE ( [avg reg] - _Pre, _Pre )

Accumulate =
VAR _Base =
    MAXX (
        FILTER ( 'Table', 'Table'[Wave] = DATE ( 2022, 9, 1 ) ),
        'Table'[avg reg]
    )
RETURN
    DIVIDE ( [avg reg] - _Base, _Base )

Is this the result you expected?

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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