LOOKUPVALUE 3 tables

MasterSonic — Mon, 17 Oct 2022 10:29:15 GMT

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

Re: LOOKUPVALUE 3 tables

amitchandak — Mon, 17 Oct 2022 11:44:21 GMT

MasterSonic , Create a new column

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

Re: LOOKUPVALUE 3 tables

MasterSonic — Mon, 17 Oct 2022 12:02:55 GMT

you are star

topic LOOKUPVALUE 3 tables in DAX Commands and Tips

LOOKUPVALUE 3 tables

Re: LOOKUPVALUE 3 tables

Re: LOOKUPVALUE 3 tables