Separate column values

[pbirookie]

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!

[Anonymous · Accepted 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.