Forum Discussion
Solved
Get data from second table based on two columns (formula for Custom Column added)
Hi PowerBI members... first post here, I'm a bit desperate. Trying to figure out how to get a value from one table based on two columns in another: Table 1 has the make and model in different col...
Easiest Way to get Table 2 to look like Table1 is click on Table2, click on Edit Query, Select all the Model columns, Right click, Unpivot columns
DAX way will become more and more complicated if you've got a lot of models. see example
Easiest Way to get Table 2 to look like Table1 is click on Table2, click on Edit Query, Select all the Model columns, Right click, Unpivot columns
DAX way will become more and more complicated if you've got a lot of models. see example