Forum Discussion
Solved
Merge columns to create new entries
Hi all, I'm brand new to Power BI so please bear with me. I imagine this is fairly standard but I can't find an article which answers what I'm looking for. I've created a reporting tool in my...
No worries, you're welcome! You can click the fx button to the left of the formula bar which will create a new step in the query. Then paste this snippet into the formula bar and replace #"Your Previous Step Name" with the name of your last step.
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Your Previous Step Name", {"Date", "Time"}, "Attribute", "Issue")
jennratten
Super User
Super UserNo worries, you're welcome! You can click the fx button to the left of the formula bar which will create a new step in the query. Then paste this snippet into the formula bar and replace #"Your Previous Step Name" with the name of your last step.
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Your Previous Step Name", {"Date", "Time"}, "Attribute", "Issue")
Brilliant, this worked.
Thanks a lot!