Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

return previous value in a calculated column

Hi I am new to power bi and Dax. i am trying to return a previous value in a table. my data is similar to below: Created Date customer id status Reference result I need 01/02/2022 1 Pro...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

    New column =

    var _max = maxx(filter(Table, [Customer Id] = earlier( [Customer Id] ) && [Created Date] < earlier([Created Date]) ),[Created Date] )

    return

    maxx(filter(Table, [Customer Id] = earlier( [Customer Id] ) && [Created Date] = _max ),[Reference] )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,

New column =

var _max = maxx(filter(Table, [Customer Id] = earlier( [Customer Id] ) && [Created Date] < earlier([Created Date]) ),[Created Date] )

return

maxx(filter(Table, [Customer Id] = earlier( [Customer Id] ) && [Created Date] = _max ),[Reference] )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you, that appears to be working