Forum Discussion
Anya_T
4 years agoFrequent Visitor
How to change view
Hi,
I have data set in
| Program | Process | 2020 Actuals | Jan'20 | Feb'20 | Mar'20 | Apr'20 | May'20 | Jun'20 | Jul'20 | Aug'20 | Sep'20 | Oct'20 | Nov'20 | Dec'20 | H1'20 | H2 2020 | H1 vs H2 Change | Comments |
| TC | z | Target | ||||||||||||||||
| PC Mapping | ||||||||||||||||||
| Hybrid | ||||||||||||||||||
| MC | ||||||||||||||||||
| MC+Hyrid | ||||||||||||||||||
| Total Resolved | ||||||||||||||||||
| 2021 Forecasts | Jan'21 | Feb'21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | H1'21 | H2 2021 | H1 vs H2 Change | Comments | ||
| Target | ||||||||||||||||||
| PC Mapping | ||||||||||||||||||
| Hybrid | ||||||||||||||||||
| MC | ||||||||||||||||||
| MC+Hybrid | ||||||||||||||||||
| Total Resolved |
but i want it in
| Program | Process | Parameter | Year | Month | Target | PC Mapping | Hybrid | MC | ROI |
| TC | HS Classification | Actual | 2020 | Jan | |||||
| Forecast | 2021 | Feb | |||||||
| Forecast | 2021 | March |
Please help.
1 Reply
- amitchandakSuper User
Anya_T , Little bit data would have helped. But you need to unpivot the month column
Create date from the month
Create common date table and join both tables with both table
Or you can append two tables
https://radacad.com/pivot-and-unpivot-with-power-bi
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query