Forum Discussion

jk13's avatar
jk13
Frequent Visitor
4 years ago
Solved

How to Lookup a value from a filtered table

Hi all,   i have the following data structure tables:   requests request_id  name 1 james 2 rob 3 sam   activities activity_id  request_id  event       date 1 1...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi jk13 ,

     

    Create column with below code:-

    create date = 
CALCULATE(
    MAX(activities[date]),
        activities[event] = "CREATE"
)

    Output:-

     

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi jk13 ,

 

Create column with below code:-

create date = 
CALCULATE(
    MAX(activities[date]),
        activities[event] = "CREATE"
)

Output:-

 

 

Thanks,

Samarth