Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Mahmed1
Helper IV
Helper IV

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...Leave...5...........21/06...

 

etc

 

how can i change the data using power query so it has all the import date across and code in a row with hours in between so i can see the change in hours day by day split by import date

 

so result like this

 

Date Selected 23/06


result

 

Code   14/06...15/06....16/06....21/06

leave.   6.5........6.5..........7.5..........5

 

i basically want to transpose all the import date and split the code into rows and have the hours split by import date so i can see how the hours changed on each import date for that code

 

hope this makes sense

 

i can do this in excel with formulas but was hoping i can achieve this ouput via powerquery

 

i dont have access to excel to load this into a view

 

i can have multiple codes but i only gave leave as an example

 

thank you

2 REPLIES 2
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Thank you

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.