Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have huge daily incoming data in this format
Manager | User Id | Column | 2021-19 |
anukshag | brabhis | Actual TIM Time (hrs) | 47.99 |
anukshag | brabhis | Actual overlap TIM Time (hrs) | 47.83 |
anukshag | brabhis | Time Diff % | 0.33% |
anukshag | btejashw | Actual TIM Time (hrs) | 21.41 |
anukshag | btejashw | Actual overlap TIM Time (hrs) | 20.52 |
anukshag | btejashw | Time Diff % | 4.18% |
anukshag | chinthum | Actual TIM Time (hrs) | 46.8 |
anukshag | chinthum | Actual overlap TIM Time (hrs) | 46.2 |
anukshag | chinthum | Time Diff % | 1.28% |
anukshag | hemag | Actual TIM Time (hrs) | 3.43 |
anukshag | hemag | Actual overlap TIM Time (hrs) | 3.37 |
anukshag | hemag | Time Diff % | 1.65% |
But i want to have this table like this
Manager | User Id | Actual TIM Time (hrs) | Actual overlap TIM Time (hrs) | Time Diff % |
anukshag | brabhis | 47.99 | 47.83 | 0.33% |
anukshag | btejashw | 21.41 | 20.52 | 4.18% |
anukshag | chinthum | 46.8 | 46.2 | 1.28% |
anukshag | hemag | 3.43 | 3.37 | 1.65% |
What are the different ways to do this?
Solved! Go to Solution.
i think you can use pivot in the PQ
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
Proud to be a Super User!
i think you can use pivot in the PQ
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
Proud to be a Super User!
Using the Pivot operation in Power Query. (EDIT: Sorry, I first mistakenly wrote Unpivot.)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |