Forum Discussion
Solved
Create a column by intersecting other columns in Power Query
Hi All In power Query , is it posiible to create the colum Final from the other 3 columns Thanks in advance Regards
Hi,
based on that data you could use:
if Text.Length([Column1]&[Column2]&[Column3]) = 1 then [Column1]&[Column2]&[Column3] else "N/A"
Hi,
based on that data you could use:
if Text.Length([Column1]&[Column2]&[Column3]) = 1 then [Column1]&[Column2]&[Column3] else "N/A"