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

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi netanel 

 

Is do you need this as Matrix visual only or are you looking to change the underlying data structure?

Only asking as the current data structure is best practice and easier to handle with DAX.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • netanel's avatar
    netanel
    Post Prodigy
    6 years ago

    hey Mariusz

     

    I need that also for matrix visual and also for zebra Table Visual and for moor table.

    But i dont whant to change my Data the Only change that i need its inside powerbi.

     

    Thanx for the quick respons!