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.
Hello. I am new to PowerBI. I have an excel sheet which has the data in this format.
I need to transform the data into below format.
Can anyone please let me know the steps for this..? It would be of much help.
Solved! Go to Solution.
Hope this video helps:
https://drive.google.com/file/d/1na2-YBiK2AGJVbmC85IQiue3E03uVikv/view?usp=sharing
Not properly useful.
You are right. I think this is complictated. You have to be sure that you have only 3 or 5 entry per user. And than you have to right code for every column. Why you want this special table?
Proud to be a Super User!
The table sturcture is fixed. There is only 3 records for each ID and Name, so no problem there. As to why it is required, we have all kinds of managers in this world who have very specific requirements 😄
How you want to sort this Section 1 to 3, per date?
Section 1 values from the earlist entry?
Proud to be a Super User!
Yes. The dates should be from Left to Right in increasing order.
Do you try the Power Query Editor and the pivot function?
https://support.microsoft.com/en-us/office/pivot-columns-power-query-abc9c8da-3be9-44c4-886e-0be331a...
Proud to be a Super User!
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |