Value previous year

[Lucie_C]

Hello,

please, can you help me. I have simple data table and I need to add Calculated coloum Value previous year:

Please, anyone does know DAX formula?

Thank you

[GDO]

You could also use the formula below:

Coloumn = LOOKUPVALUE( Table1[Value] ; Table1[Company] ; Table1[Company] ; Table1[Date] ; SAMEPERIODLASTYEAR( Table1[Date] ) )

[v-piga-msft · Accepted solution]

Hi @Lucie_C,

You could create the calculated column with the formula below.

Column =
CALCULATE (
    MAX ( 'Table1'[Value] ),
    FILTER (
        'Table1',
        YEAR ( 'Table1'[Date] )
            = YEAR ( EARLIER ( 'Table1'[Date] ) ) - 1
            && [Company] = EARLIER ( Table1[Company] )
    )
)

Here is your desired output.

Hope this can help you!

Best Regards,

Cherry

[Anonymous]

Hello,

I have the same case but with a second date column called "As of date", which will be selected as a filter in the visual.

How can I expand the formula to include that second date?

Thank you!

[Lucie_C]

Thank you 🙂