LOOKUPVALUE 3 tables

[MasterSonic]

Hello,

TableMain has ArrvialTime columns to lookup from 2 different tables.

Table1 key is Group and Table2 key is Category

Curretly I created columns :
Table 1 ArrivalTime and Table 2 ArrivalTime with LOOKUPVALUE and Combined arrival time

using IF(ISBLANK....

question to you, is there any more efficent way to do it please? 

TableMain

Code	Group	Category	Table 1 ArrivalTime	Table 2 ArrivalTime	Combined arrival time
555	Group1	Category 1		1/1/2022	1/1/2022
666	Group1	Category 1		1/1/2022	1/1/2022
777	Group2	Category 2	1/1/2022		1/1/2022
888	Group2	Category 2	1/1/2022		1/1/2022
999	Group4	Category 3		3/3/2023	3/3/2023

Table1

Group	ArrivalTime
Group2	1/1/2022
Group3	3/3/2023

Table2

Category	ArrivalTime
Category 1	1/1/2022
Category 3	3/3/2023

[amitchandak · Accepted solution]

@MasterSonic , Create a new column

coalesce(maxx(filter(Table1, Table1[Category] = tablemain[Category]) , Table1[ArrivalTime]) ,  maxx(filter(Table2, Table2[Category] = tablemain[Category]) , Table2[ArrivalTime]) )

[MasterSonic]

you are star