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`m receiving a rawdata extract from a software and need it to generate a viz reports. The data contains information for both person and the projects they are working on throughout a period.
The issue is that the column rawdata contains both person and project names. I need to get the person names in a separate column and track each person`s performance over a monthly basis.
Some samples of source and target data are below.
Please help!
Solved! Go to Solution.
Hi,
Attached is the link to pbix for your requirement. You will need to use Power Query to transform the data.
https://1drv.ms/u/s!AikPceQOhqFEhBG7L5apdqs1dbsD?e=e9gqht
This is how i have transformed it.
Thanks.
Hi,
Attached is the link to pbix for your requirement. You will need to use Power Query to transform the data.
https://1drv.ms/u/s!AikPceQOhqFEhBG7L5apdqs1dbsD?e=e9gqht
This is how i have transformed it.
Thanks.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |