Forum Discussion
Solved
Power Query: Duplicate rows with multiple names
Hello, Is it somehow possible to do the following in Power Bi Query: When I have a project, with different people, can I extract it to multiple lines? So for example: Names Projec...
Hi IAM ,
See below outcome:
Simple 3 transformation steps:
1. Add a custom column and add formula below to split the name by ", " and return as a list:
Text.Split([Names],", ")
2. Expand the list to new rows
3. Add a custom column to split the hour equally with formula below:
[Hours]/List.Count(Text.Split([Names],", "))
Regards
KT
Woww thanks!!!