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...
ImkeF
Community Champion
Community ChampionHi 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.