Forum Discussion
Help Needed with Transposing Price Records for Chart Visualization
Hello everyone,
I have what I believe is an easy-to-solve challenge, but I can't wrap my head around it. I'm hoping someone here can show me how to do it. Thank you in advance for taking the time to help!
I have a table containing simple price records, and I would like to transpose it into an additional table so that I can use it to create line charts.
Original Table of Price Records:
| Name | Valid Start | Valid End | Price Min | Price Max |
| ------------ | --------------- | --------------- | --------------- | --------------- |
| Apple | 2024-10-01 | 2024-12-31 | 5 | 7 |
| Apple | 2025-01-01 | 2030-12-31 | 7 | 7 |
| Banana | 2024-10-01 | 2030-12-31 | 3 | 3 |
| --- | ||||
| Desired Transposed Table for Chart Visualization: | ||||
| Period | Apple-Min | Apple-Max | Banana-Min | Banana-Max |
| ------------ | --------------- | --------------- | ---------------- | ---------------- |
| 2024-10 | 5 | 7 | 3 | 3 |
| 2024-11 | 5 | 7 | 3 | 3 |
| 2024-12 | 5 | 7 | 3 | 3 |
| 2025-01 | 7 | 7 | 3 | 3 |
| 2025-02 | 7 | 7 | 3 | 3 |
| etc. | ||||
| --- |
Nighthawk_2 see attached pbix file, tweak the solution as you see fit. I'm sure it will get you started, feel free to reach out if you have any questions.
3 Replies
Nighthawk_2 see attached pbix file, tweak the solution as you see fit. I'm sure it will get you started, feel free to reach out if you have any questions.
Awesome! Thank you very much, this looks like a very simple and elegant solution. Thank you again, much appreciated!!
Nighthawk_2 happy to help.
