Forum Discussion

jhollingworth's avatar
jhollingworth
Frequent Visitor
2 years ago
Solved

Lookup value in same table, matching to previous date

Hello, I have a problem that I thought was going to be an easy fix. Unfortunately, I can't seem to do it. I think I'm making it more complicated than it needs to be.   I have a simple table like b...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    Hi jhollingworth 

    If you wanna do it as a measure, Try this.

     

    Previous Value =
    VAR CurrentDate = MAX('Table'[Date])
    RETURN
        CALCULATE(
            MAX('Table'[Value]),
            FILTER(
                ALL('Table'),
                'Table'[Date] < CurrentDate
            )
        )
     If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
jhollingworth's avatar
jhollingworth
Frequent Visitor
2 years ago

Thank you everyone for the help. The measure work posted by NaveenGandhi. The two calculated columns both resulted in blank columns. I will play around with those.

Thanks again.