Forum Discussion

netanel's avatar
netanel
Post Prodigy
6 years ago
Solved

Pivot Year Please Help

Hello everyone! I have DATA as in the red color image And I want to turn it into the yellow color I tried some formulas and PIVOT and it doesn't work I would love for a simple formula or help wit...
General Comment
  • Fowmy's avatar
    Fowmy
    6 years ago

    netanel 

    You don't need to do any transformation to get the data presented in the layout you wanted. Just add an index column in Power Query and insert a Matrix Visual then drop Year in Column, Index in Row, and Amount in Value, Done.

    Please Check this file: https://1drv.ms/u/s!AmoScH5srsIYgYFhaaJI141dwgVkhg?e=4rap1Z

    Mark this reply as a solution if I answered your question

netanel's avatar
netanel
Post Prodigy
6 years ago

the first link dont work.

 

and link number two is greet but dont do the work for me....

 

Tanks