Solved: Create a column by intersecting other columns in P...

Nazdac911 · ‎04-05-2023

Hi All

In power Query , is it posiible to create the colum Final from the other 3 columns

Thanks in advance
Regards

DOLEARY85 · ‎04-05-2023

Hi,

based on that data you could use:

if Text.Length([Column1]&[Column2]&[Column3]) = 1 then [Column1]&[Column2]&[Column3] else "N/A"

DOLEARY85 · ‎04-05-2023

Hi,

based on that data you could use:

if Text.Length([Column1]&[Column2]&[Column3]) = 1 then [Column1]&[Column2]&[Column3] else "N/A"

Create a column by intersecting other columns in Power Query