Assign Tasks Evenly to Team Members using Modulo in Power Query

preview_player
Показать описание
In this video, I will show you how to assign tasks evenly in a team using modulo in POWER QUERY.

0:00 Intro
0:43 Load tables in PQ
1:41 Create team count
2:05 Use Modulo
3:22 Merge Queries to add Team Names
5:58 Checking and outro

Watch the whole video for further explanation of the process!

Link to download the sample file:

Link on Playlist: Learn Spreadsheet Power Query:

Thanks for your time and I hope you learn something from it.
Help me to reach my target audience by sharing my videos with the right people.
Don’t forget to SUBSCRIBE!
Рекомендации по теме
Комментарии
Автор

Excellent technic and very useful for what I'm facing now. Thank you very much from Thailand.

KhajonsakLun
Автор

What happens if I need to add more dates? Will the names still get randomly generated for the daily tasks?

Christian-phpo
Автор

Hello, thank you for the tutorial! I have one question, how do I assign the task if I have part time members on the team that is not available all week. As the assign of tasks weight will be different. Thank you

BronzeVBaker
Автор

What do I do if the same names are used more then the others?

Christian-phpo
join shbcf.ru