Create a column by intersecting other columns in Power Query

Question

Hi All&nbsp;In power Query , is it posiible to create the colum Final from the other 3 columns&nbsp;&nbsp;Thanks in advance&nbsp;Regards&nbsp;

doleary85 · Accepted Answer

Hi,&nbsp;based on that data you could use:&nbsp;if Text.Length([Column1]&amp;[Column2]&amp;[Column3]) = 1 then [Column1]&amp;[Column2]&amp;[Column3] else "N/A"&nbsp;&nbsp;

Forum Discussion

Create a column by intersecting other columns in Power Query

1 Reply

Related content

Create columns group

Create table with intersection column

Creating a date column

Creating a custom column

intersecting streams matrix