Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
DataSkills
Resolver I
Resolver I

Using Rankx to get a dynamic scheduling matrix (how to)

Hi all, 

 

I recently had a piece of work to do where I had to build a scheduling matrix for a customer. I had to rank entities and then allocate them based on rank to a specific day of the week. I solved this using what to me was a rather elegant solution, so I decided to document it (mostly for my own purposes since I may need to do something similar in the future). 

 

Anyway, if you have any interest in seeing how I solved this problem, you can check out the  YouTube  video I created. 

 

I hope it helps someone at some point. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @DataSkills ,

Thanks for sharing your method on how to get a dynamic scheduling matrix using Rankx, you can accept your method as a solution.

Thanks for your contribution.

 

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @DataSkills ,

Thanks for sharing your method on how to get a dynamic scheduling matrix using Rankx, you can accept your method as a solution.

Thanks for your contribution.

 

Best Regards

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.