topic Re: How to union multiple columns in a new table in DAX Commands and Tips

How to union multiple columns in a new table

ScripTeapot_ — Mon, 15 May 2023 07:53:21 GMT

I need help to order this data in a new table; I made a mock data to exemplify how they gave me the data.

The thing is, in january a certain amount of clients were charged for a number of day of service but they not necessarily paid in january. The same for the charged period of february and march. I need to order all the payment columns and all the dates columns into one column for each one; all the jan dates and amount first, the feb next and so on. Also, I need to identify from what month charged is. Like the next example:

The amount of clients may differ one month from another, so a need the blank spaces to see who has not paid.

I need this data in a new table to visualize correctly.

Re: How to union multiple columns in a new table

tamerj1 — Mon, 15 May 2023 08:27:56 GMT

Hi ScripTeapot_

Better to use poerr query to unpivot these columns. The column headers will become attributes in the Attribute column and the values will be in the Value column

Re: How to union multiple columns in a new table

ScripTeapot_ — Mon, 15 May 2023 08:39:42 GMT

I already try this, but it didn't work. I try unpivot the payment columns but the dates interact in a strange way. I had a similar case a few months ago but I don't know why it does not work now.

Re: How to union multiple columns in a new table

tamerj1 — Mon, 15 May 2023 08:46:25 GMT

ScripTeapot_
Then split it into 3 queries each one Date and one Value column then append the 3 queries.