Forum Discussion
Setting a variable in LOOKUPVALUE
Hi, I need to define a variable for the <result_columnName> in LOOKUPVALUE. I am working with 2 tables: Job Titles (JT) with Regional Rates (RR) and Employees with their JT and RR. In Excel I c...
You should unpivot the second table: https://radacad.com/pivot-and-unpivot-with-power-bi
Then you will able to use lookup
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Hi,
sometimes it makes sense to restructure your data to work best with Power BI . I would unpivot the data in the Job Type / Rate Matrix, so you have a row for each rate per job. as you are using 2 columns to lookup then you could use SELECTCOLUMNS to return a value into a new column in your table from the rate table using the Job Type and Rate as filters.