Forum Discussion
Helper VSplit time per project
IvanS , In power query first add this column
Dist Time = [Logged Time]/ List.Count(Text.Split([Projects], ",") )
Power Query- Text.Split: https://youtu.be/Fn5mNEuRNVg
List.Count and List.Distinct: https://youtu.be/zNREVnoAHwM
Now you can use split by Delimiter into rows : https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
Super UserIvanS , In power query first add this column
Dist Time = [Logged Time]/ List.Count(Text.Split([Projects], ",") )
Power Query- Text.Split: https://youtu.be/Fn5mNEuRNVg
List.Count and List.Distinct: https://youtu.be/zNREVnoAHwM
Now you can use split by Delimiter into rows : https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag