Im trying to find the CUSTOMER NAME in another table with CUSTOMER ID.
Y try with lookup formula:
LOOKUP([CUSTOMER ID],CUSTOMERS,CUSTOMER ID,NAME)
ALWAYS GIVE ME THE SAME VALUE IN ALL ROWS.
and also I tried.
ANY(
SELECT(
CUSTOMERS[NAME],
([CUSTOMER ID] = [CUSTOMER ID]),
)
)
With same value in all rows.
| CUSTOMER ID | CUSTOMER NAME | WORK STATS |
|---|---|---|
| 11111111 | ? | FINISHED |
| 3333333 | ? | IN PROGRESS |
| 11111111 | ? | DELAYED |
FIND THE NAME ABOVE IN THE TABLE BELOW
| CUSTOMER ID | CUSTOMER NAME |
|---|---|
| 11111111 | EMILIANO |
| 3333333 | CONRADO |
column key is CUSTOMER ID
Can somebody help me with this?, I think is not very complicated thing, but I dont know how to solve it.
Thanks.
LOOKUP([_THISROW].[CUSTOMER ID], “CUSTOMERS”, “CUSTOMER ID”, “CUSTOMER NAME”)
THIS WAS SOLUTION I FOUND.