putting Column 1 + Column 2 together in one column

Anonymous — Wed, 22 Jun 2022 20:24:30 GMT

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!

Re: putting Column 1 + Column 2 together in one column

Jihwan_Kim — Thu, 23 Jun 2022 03:50:16 GMT

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 )

topic Re: putting Column 1 + Column 2 together in one column in DAX Commands and Tips

putting Column 1 + Column 2 together in one column

Re: putting Column 1 + Column 2 together in one column