Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

LOOKUPVALUE with IF

Thank you in advance for your help.   I have two tables: Arrest Table includes date of arrest, name number, and current street address NMHistory Table includes name number, street address, Begin ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    You can create a new calculated column in the Arrest table

    Steet at Arrest =
MAXX (
    FILTER (
        NMHistory,
        NMHistory[Number] = Arrest[NameNum]
            && NMHistory[Begin Date] <= Arrest[Date]
            && NMHistory[Exp Date] >= Arrest[Date]
    ),
    NMHistory[Street]
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
You can create a new calculated column in the Arrest table

Steet at Arrest =
MAXX (
    FILTER (
        NMHistory,
        NMHistory[Number] = Arrest[NameNum]
            && NMHistory[Begin Date] <= Arrest[Date]
            && NMHistory[Exp Date] >= Arrest[Date]
    ),
    NMHistory[Street]
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much!!! You saved the day again. 🙂