How to Lookup a value from a filtered table

Question

Hi all,&nbsp;i have the following data structure tables:&nbsp;requestsrequest_id&nbsp;name1james2rob3sam&nbsp;activitiesactivity_id&nbsp;request_id&nbsp;event&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;date11CREATE2022-01-1021UPDATE2022-01-1232CREATE2022-01-12&nbsp;I want to add a column "create_date" to the requests-table with the date from the activities where the event is CREATE.&nbsp;There is a one-to-many relationship between requests and activities.&nbsp;I know this should not be that hard, but somehow i struggle to come op with an easy solution. My idea was using lookupvalue based on the filtered activities-table.&nbsp;Thanks for your help!

samarth_18 · Accepted Answer

Hi&nbsp;jk13&nbsp;,&nbsp;Create column with below code:-create date = 
CALCULATE(
    MAX(activities[date]),
        activities[event] = "CREATE"
)Output:-&nbsp;&nbsp;Thanks,Samarth

Forum Discussion

How to Lookup a value from a filtered table

1 Reply

Related content

Dynamic filter using lookups

Lookup rank value?

Lookup value

Lookup with Filter

Lookup help

activity_id	request_id	event	date
1	1	CREATE	2022-01-10
2	1	UPDATE	2022-01-12
3	2	CREATE	2022-01-12

request_id	name
1	james
2	rob
3	sam