Forum Discussion
Setting a variable in LOOKUPVALUE
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
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
Thank you,
Onces Pivoted I was able to successfully build a measure and a column.
For the Measure I needed to create 2 variable measures"MAX('Employee Table[Job Title])" and
"MAX('Employee Table[Rate ID])"
then I created the measure
"LOOKUPVALUE('JobTable[Rate Value], 'JobTable[Job Title}, Measure[Job Title], JobTable[Rate ID}, Measure[Rate])"
For the column I didn't need the measure names and used the column names from the Employee Table.