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.
LinkedIn
Twitter
