Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago
Solved

Merge columns based on condition

Hello Experts!   A have a large number of columns per table that end with 'Other'. How can I merge these columns (1 to 2) if the condition (column name to end with 'Other') gets satisfied in power ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this. You will need to replace #"Previous Step" and Column1 as per you need.

    Then you can right click on 2nd column and Remove column

     

    = Table.ReplaceValue(#"Previous Step",each [Column1],each if [Column1]<>null and [Other]<>null then [Column1]&" "&[Other] else [Column1],Replacer.ReplaceValue,{"Column1"})

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dom87326 ,

 

Could you tell me if Vijay_A_Verma 's method helps you solve the issue?If it does, kindly Accept it as the solution.

More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin