Forum Discussion
Merging different columns using line breaks and "-"
Hi, Burubear
Here is the table. The pbix file is attached in the end.
Table:
You may go to 'Add Coumn' ribbon, click 'Custom Column', paste the following codes in the 'Custom column formula'.
=let teama = if [TeamA]="" then "" else "-"&[TeamA], teamb = if [TeamB]="" then "" else "-"&[TeamB], teamc = if [TeamC]="" then "" else "-"&[TeamC], list = List.Select({teama,teamb,teamc},each _<>"") in Text.Combine(list,"#(lf)")Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sorry not that advance yet in codings and using advanced query editor, would you show which formula used/ buttons clicked in each step
Hi, Burubear
Here is the table. The pbix file is attached in the end.
Table:
You may go to 'Add Coumn' ribbon, click 'Custom Column', paste the following codes in the 'Custom column formula'.
=let
teama =
if [TeamA]="" then "" else "-"&[TeamA],
teamb =
if [TeamB]="" then "" else "-"&[TeamB],
teamc =
if [TeamC]="" then "" else "-"&[TeamC],
list = List.Select({teama,teamb,teamc},each _<>"")
in
Text.Combine(list,"#(lf)")
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you so much! it's now easier to understand for new PBI users like me. Works really well and got the result that I wanted!