Forum Discussion

67nmark's avatar
67nmark
Helper I
6 years ago
Solved

DAX calculated column- get previous record value

Hello, I've looked for answers but can't get what I want. Essentially I need a column that brings the value associated with a previous date onto the current row. The image below shows the requirement...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    6 years ago

    Try this

     

    Last Val = CALCULATE(LASTNONBLANK('Table'[Value],'Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[Date]<EARLIER('Table'[Date])))
FarhanAhmed's avatar
FarhanAhmed
Community Champion
6 years ago

Try this

 

Last Val = CALCULATE(LASTNONBLANK('Table'[Value],'Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[Date]<EARLIER('Table'[Date])))
67nmark's avatar
67nmark
Helper I
6 years ago

Perfect. Thanks so much 🙂