Forum Discussion

Lucie_C's avatar
Lucie_C
Frequent Visitor
8 years ago
Solved

Value previous year

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
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

GDO's avatar
GDO
Regular Visitor
6 years ago

You could also use the formula below:

 

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