How to combine two columns from the same table

[ScorpionKing]

Hi everyone! Pls help me combine two columns from the same table as shown below.

Thanks in advance!

[Zubair_Muhammad]

Hi @ScorpionKing

Go to Modelling Tab ... and select the NEW TABLE button

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]

@ScorpionKing

See the attached file here

[ScorpionKing]

Hi @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?

Thanks

[Zubair_Muhammad]

HI @ScorpionKing

In the above example you needed only 3 columns as output

Do you need 100 columns as output and or only 3 out of 100?

[Zubair_Muhammad]

@ScorpionKing

Using Query Editor,

You can use the Append Queries to do the same Union I did using DAX

Create a Duplicate Query and then append the Original Query to that Duplicate Query