Forum Discussion
Pulling referential label descriptions from label table
New here and new to Power BI. Working with a 3rd party DB that has many tables with integers stored in many monthly fields (month 1, month 2...) in each table. These integer values relate to one t...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi JohnAnderson,
Based on my understanding, your table structure might be:
To Join these two tables based on values for each month in Table1 and [Value] in TableL, you should first Unpivot Table1. Select columns Month1, Month2, Month3... then, click "Unpivot Columns" option under Transform tab in Query Editor mode.
Then, merge these two tables. (Home -> Merge queries as new)
If above result doesn't meet your requirement, please figure out how to join tables and show us your desired output with image.
Regards,
Yuliana Gu