Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |