putting Column 1 + Column 2 together in one column

[Anonymous]

Hi! 
I am trying to go from this:

Payment 1	Amount 1	Payment 2	Amount 2
Jan 1	10	Feb 1	20
Jan 2	15	Feb 2	25

to this:

Payment	Amount
Jan 1	10
Feb 1	20
Jan 2	15
Feb 2	25

and I can't do this in the query editor because these are all custom columns added in the Tabular Data View.

Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

I assume you want to create a new table by using DAX formula.

Please check the below picture and the attached pbix file.

It is for creating a new table.

New Table = 
VAR _tableone =
    SELECTCOLUMNS (
        Source,
        "@Payment", Source[Payment 1],
        "@Amount", Source[Amount 1]
    )
VAR _tabletwo =
    SELECTCOLUMNS (
        Source,
        "@Payment", Source[Payment 2],
        "@Amount", Source[Amount 2]
    )
RETURN
    UNION ( _tableone, _tabletwo )