Forum Discussion
Data transform using power query
Could you please someone suggest me for below issue. Thank you in advance.
I have below format data
| 2026 | actual | budget | ||||
| p1 | p2 | p3 | p1 | p2 | p3 | |
| revenue | 1 | 2 | 3 | 4 | 5 | 6 |
| food cost | 7 | 8 | 9 | 10 | 11 | 12 |
| 2025 | actual | budget | ||||
| p1 | p2 | p3 | p1 | p2 | p3 | |
| revenue | 1 | 2 | 3 | 4 | 5 | 6 |
| food cost | 7 | 8 | 9 | 10 | 11 | 12 |
How can I transform this data to below format
| subject | year | period | Actual | budget |
| revenue | 2026 | p1 | 1 | 4 |
| revenue | 2026 | p2 | 2 | 5 |
| revenue | 2026 | p2 | 3 | 6 |
| food cost | 2026 | p1 | 7 | 10 |
| food cost | 2026 | p2 | 8 | 11 |
| food cost | 2026 | p2 | 9 | 12 |
| revenue | 2025 | p1 | 1 | 4 |
| revenue | 2025 | p2 | 2 | 5 |
| revenue | 2025 | p2 | 3 | 6 |
| food cost | 2025 | p1 | 7 | 10 |
| food cost | 2025 | p2 | 8 | 11 |
| food cost | 2025 | p2 | 9 | 12 |
Hi Anonymous,
The updated PBIX file is attached for your reference.
Here, the data has been reshaped to the required format (Subject, Year, Period, Actual, Budget) using Power Query so that it can be used directly for reporting and further analysis.Please review the updated file and let us know if everything looks good or if any additional adjustments are needed.
Thank you.Hi Anonymous ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.
