Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create custom column with cocatenated value

Hello My table has 5 columns with column header Col1, Col2, Col3, Col4 and Col5 All of them contains values True or False In Power Query I will create new custom column with name Col6 This Column...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    Try this as code fro your custome column:

    = Text.Combine({if [Col1] then "Col1" else null,if [Col2] then "Col2" else null, if [Col3] then "Col3" else null,if [Col4] then "Col4" else null,if [Col5] then "Col5" else null}, "|")

     


    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Try this as code fro your custome column:

= Text.Combine({if [Col1] then "Col1" else null,if [Col2] then "Col2" else null, if [Col3] then "Col3" else null,if [Col4] then "Col4" else null,if [Col5] then "Col5" else null}, "|")

 


 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks - worked 🙂