Forum Discussion

Frequent Visitor

6 years ago

Solved

Separate column values

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 perio...

Need Help

Anonymous
6 years ago
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.

Anonymous

Not applicable

6 years ago

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.

Forum Discussion

Separate column values

Related content

separate values into columns

Split a column into two separate columns

Drill Through with comma separated values

Splitting Column values

Formatting values separately in unpivot value column