Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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
Proud to be a Datanaut!
Thank you
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |