Forum Discussion

Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
3 years ago

Transpose Data like this

Hey,   i have a table where i have  Date...Code....Hours....Import Date 23/06...Leave...6.5.......14/06.... 23/06...Leave...6.5.......15/06.... 23/06...Leave...7.5.......16/06.... 23/06...Leav...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi Mahmed1 ,

 

You don't need to do anything with the data in Power Query - it's already in the perfect structure.

If you want to see the change in values, then put your data either into a Pivot Table or Chart if you're using Excel, or into a Matrix visual or Chart if youre using Power BI.

 

Pete

  • Mahmed1's avatar
    Mahmed1
    Icon for Helper IV rankHelper IV
    3 years ago

    Thank you