Forum Discussion
JohnAnderson
9 years agoNew Member
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...
ImkeF
9 years agoCommunity Champion
Hi John,
it would be easiest if you unpivot the month-columns of your Table1, then merge the TableL on the (newly created) attribut-column, and - if necessary - pivot back.
But normally, the pivot-back operation is not such a good idea for a data model.