Forum Discussion
How to use a mid-table row as the column headers, while still keeping the above table rows
Good day everyone! I am relatively new to Power Bi Desktop and am hoping for answers to my current problem. I've imported data from an Excel Workbook and am now trying to format my data. I've...
Idrissshatila
Super User
Super UserAnonymous ,
in the last row after the "in" replace the #"Changed Type" with #"Promoted Headers"
No dice, unfortunately.
- Idrissshatila
Anonymous , replace the promoted header line with this
#"Promoted Headers" = Table.PromoteHeaders(Table.Skip(#"Changed Type",1), [PromoteAllScalars=true])
This works, but unfortunately, I've lost some of the data