Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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
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
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.
@ScripTeapot_
Then split it into 3 queries each one Date and one Value column then append the 3 queries.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |