LOOKUPVALUE Returns False Query, but not desired data.

AL472 — Tue, 13 Jun 2023 17:57:10 GMT

I have a column in Table 1 labeled "Responsible Design Group" which contains 70 distinct values across 1300 cells. I am attempting to add a column to Table 1 labeled "Department Name" using the LOOKUPVALUE feature. I need to pull data from Table 2, which contains the Department Names and their corresponding Design Group Labels. The DAX command I have been using is:
LOOKUPVALUE('Table 2'[Department Name], 'Table 2'[Design Group Label], 'Table 1'[Responsible Design Group])
The 70 disctinct values that appear in 'Table 1'[Responsible Design Group] are listed once apiece in 'Table 2'[Design Group Label].

I have ensured all my data is of the same type, text. When I imput this command it returns blank columns, when I add (..., "TBD") to the end of the LOOKUPVALUE command, all the cells in the 'Table 1'[Department Name] column change to "TBD". Is there any advice for this?

Re: LOOKUPVALUE Returns False Query, but not desired data.

tamerj1 — Wed, 14 Jun 2023 13:41:41 GMT

AL472
Double check if the text matches in both columns. It could be an extra word, letter, space or hidden character. Try to trim and clean both columns in power query.

topic Re: LOOKUPVALUE Returns False Query, but not desired data. in DAX Commands and Tips

LOOKUPVALUE Returns False Query, but not desired data.

Re: LOOKUPVALUE Returns False Query, but not desired data.