Forum Discussion

TimK's avatar
TimK
Helper III
2 years ago
Solved

Matrix issue

I am trying to achieve something in both PowerBI and Excel   Basically i have some data: Sales Person Product Spent 2023 2024 2025 2026 Simon One      2,500.00      2,125.00      2...
Need Help
  • BITomS's avatar
    BITomS
    2 years ago

    Hi TimK ,

     

    From your description it sounds like you have just missed the transformation to unpivot the 'spent' column as well as the years? Just apply the same transformation logic you are using for years to the 'spent' column.

     

    Hope this helps.

     

     

BITomS's avatar
BITomS
Solution Supplier
2 years ago

Hi TimK ,

 

From your description it sounds like you have just missed the transformation to unpivot the 'spent' column as well as the years? Just apply the same transformation logic you are using for years to the 'spent' column.

 

Hope this helps.