Forum Discussion
table transformation
Hi everyone, I have a table like in the example below I would like to transform it this way can someone help me?
Hi dufoq3 ,
I'm sorry, I'll write in detail what I have and what I expect.
I have this table that is compiled by hand on sharepoint by my management, unfortunately the format is decided by them for a question of visibility and their convenience.
| Mese | Jan-24 | |||
| WBS | Revenue | Cost | Delta EAC Revenue | Delta EAC Cost |
| P.00434.1.12 | 4000.00 | 2800.00 | 0.00 | 0.00 |
| P.00615.1.01 | 19000.00 | 15000.00 | 0.00 | 0.00 |
| P.00906.1.01 | 8700.00 | 8000.00 | 0.00 | 0.00 |
I would like to transform it into this format to have the possibility of better managing the data in power bi desktop and I would like to do this by transforming the data directly into power query
| Mese | WBS | Revenue | Cost | Delta EAC Revenue | Delta EAC Cost |
| 1/1/2024 | P.00434.1.12 | 4000.00 | 2800.00 | 0.00 | 0.00 |
| 1/1/2024 | P.00615.1.01 | 19000.00 | 15000.00 | 0.00 | 0.00 |
| 1/1/2024 | P.00906.1.01 | 8700.00 | 8000.00 | 0.00 | 0.00 |
This format is necessary for me to create graphs and formulas in dax later. This is what I think but there may also be a better solution, I'm open to any advice.
Thank you and sorry for the misunderstanding
I'm giving you last chance:
Could you answer my question no 2 and 3 please?