Forum Discussion
Split row into multiple rows, while combining columns
Hi all, I have inherited a dataset which I need to manipulate in Power BI to track project progress. All information is captured monthly in a single table, so all 150+ columns in a single row. ...
KyleFurner How are the columns named? I would suggest doing an 'unpivot columns' or 'unpivot other columns' in Power Query for this one. If they're named consistently with the milestone name, then you'll get close to what you need after a split/extract on the attribute column.
If they are named "Milestone Name", "Milestone Status" "Milestone Target" you'll have even more success.
If the names aren't helpful, you'll need a bit more custom function but still definitely do this in Power Query, NOT DAX.
Please share sample column names so we can assist further if needed.