How to combine two columns from the same table

Question

Hi everyone! Pls help me combine two columns from the same table as shown below.&nbsp;Thanks in advance!&nbsp;

zubair_muhammad · Answer

Hi ScorpionKing&nbsp;Go to Modelling Tab ... and select the NEW TABLE button&nbsp;NEW Table =
UNION (
    SELECTCOLUMNS (
        TableName,
        "Location", TableName[Location],
        "Reason Code", TableName[Unserved Code],
        "Quantity", TableName[Qty]
    ),
    SELECTCOLUMNS (
        TableName,
        "Location", TableName[Location],
        "Reason Code", TableName[Return Code],
        "Quantity", TableName[Qty1]
    )
)

zubair_muhammad · Answer

ScorpionKing&nbsp;See the attached file here&nbsp;

scorpionking · Answer

Hi&nbsp;Zubair_Muhammad, appreciate your very fast reply. Is there a way not to label all my columns? I have 100 columns and 800k rows. Would there be an impact in the speed? Is there a way to do it in the Query table?&nbsp;Thanks&nbsp;&nbsp;

zubair_muhammad · Answer

HI ScorpionKing&nbsp;In the above example you needed only 3 columns as output&nbsp;Do you need 100 columns as output and or only 3 out of 100?&nbsp;

zubair_muhammad · Answer

ScorpionKing&nbsp;Using Query Editor,&nbsp;You can use the Append Queries to do the same Union I did using DAX&nbsp;Create a Duplicate Query and then append the Original Query to that Duplicate Query&nbsp;&nbsp;

Forum Discussion

How to combine two columns from the same table

5 Replies

Related content

Tables combine

Combine Column

Combining Column Data

Combine columns into 1

Combining Columns in Different Tables