Forum Discussion

BornSlippy99's avatar
BornSlippy99
Regular Visitor
3 years ago
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...
Need Help
  • jennratten's avatar
    jennratten
    3 years ago

    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")

     

     

BornSlippy99's avatar
BornSlippy99
Regular Visitor
3 years ago

Hi Jenn, 

 

Thanks for the quick response.

 

Apologies, does that code go into the advanced editor for that query, and does any of the existing code need changed?

 

Thanks again

jennratten's avatar
jennratten
Icon for Super User rankSuper User
3 years ago

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")

 

 

  • BornSlippy99's avatar
    BornSlippy99
    Regular Visitor
    3 years ago

    Brilliant, this worked.

     

    Thanks a lot!