LOOKUPVALUE Returns False Query, but not desired data.
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?
LOOKUPVALUE with multiple matches in Search_ColumnName
Hi everyone, I'm on a Power BI project needing me to use the LOOKUPVALUE function (I guess) For example I have: TABLE 1: Code_t1 Value Date A100 100 09/2019 A200 200 09/2019 A100 110 10/2019 A200 210 10/2019 ... TABLE 2: Code_t2 resultColumn A100 A100 A100 A100 The goal of the project is to convert an old Excel file used as reporting into a power BI Project. datas are collected every months on last day. I have the following formula in resultColumn: ResultColumn = LOOKUPVALUE(Table1[Value];Table1[Code_t1];Table2[Code_t2]) It's working when each Code are unique in Table1, but not with identical values (when we have 2 or more months), Something else that can help: the couple Code_t1/Date is always Unique ! so how can i do to collect all Values even if the code is not unique, maybe using the date to help ?