I want PBI to automatically assign resources to unassigned or new tickets

[Newbie22]

Hi Everyone,

I'm currently building a tracker on power bi and I wish to have a feature on which powerbi can automatically assign/designate resources to attend new tickets or unassigned tickets. Let's say for example:

I have two resources (list is in excel and connected to existing PBI). This will be updated everyday whoever are available.

User ID	Resource Name
MK12345	Michael John
MK12346	Chris Kyle

I want PBI to automatically assign them to all of the new tickets in my raw data. It doesn't matter if equal distribution or not.

Here's a sample raw data if you want to try. All are new tickets. 

Created	Case Number	HR Category	Assigned To	Updated	HR Subcategory	Updated by	Due date	Status
11-10-2022 11:54:19	HRC13210422	Online Item		13-10-2022 12:43:50	Online Item Enquiry	DE010026976	12-10-2022 11:54:19	Work in Progress
13-10-2022 10:43:48	HRC13234408			13-10-2022 10:43:48		DE010038280	Work in Progress
13-10-2022 10:49:52	HRC13234460			13-10-2022 10:49:53		DE010038280	Work in Progress
13-10-2022 11:28:48	HRC13234836			13-10-2022 11:28:49		DE010038280	Work in Progress
13-10-2022 11:52:24	HRC13235056			13-10-2022 11:52:25		DE010063244	Work in Progress
13-10-2022 11:56:36	HRC13235106			13-10-2022 11:56:36		CH010033768	Work in Progress
13-10-2022 12:19:34	HRC13235366			13-10-2022 12:36:50		XE021305326	Work in Progress
13-10-2022 12:21:22	HRC13235386			13-10-2022 12:21:22		guest		Work in Progress
13-10-2022 12:23:29	HRC13235413			13-10-2022 12:23:29		guest		Work in Progress
13-10-2022 12:30:07	HRC13235497			13-10-2022 12:30:07		DE010038136	Work in Progress
13-10-2022 12:32:50	HRC13235532			13-10-2022 12:32:51		DE010045465	Work in Progress
13-10-2022 12:38:55	HRC13235611			13-10-2022 12:38:56		DE010054630	Work in Progress
13-10-2022 12:43:54	HRC13235669			13-10-2022 12:43:54		guest		Work in Progress
13-10-2022 12:47:50	HRC13235706			13-10-2022 12:47:51		DE010059991	Work in Progress
13-10-2022 12:49:47	HRC13235723			13-10-2022 12:49:48		DE010052678	Work in Progress
13-10-2022 12:52:59	HRC13235776			13-10-2022 12:53:00		DE010064506	Work in Progress
13-10-2022 13:12:48	HRC13236078			13-10-2022 13:12:49		DE010006199	Work in Progress
13-10-2022 13:14:52	HRC13236121			13-10-2022 13:14:53		DE010014172	Work in Progress
13-10-2022 13:21:38	HRC13236210	Scheduled Offerings		13-10-2022 13:21:49	Scheduled Offering	DE010038192	Assigned
13-10-2022 13:23:30	HRC13236229			13-10-2022 13:23:31		AT010014378	Work in Progress
13-10-2022 13:25:21	HRC13236244			13-10-2022 13:25:21		DE010042582	Work in Progress
13-10-2022 13:37:55	HRC13236431			13-10-2022 13:37:55		DE010063311	Work in Progress
13-10-2022 14:07:30	HRC13236896			13-10-2022 14:07:30		guest		Work in Progress
13-10-2022 14:15:52	HRC13237019			13-10-2022 14:15:53		DE010054630	Work in Progress

Let me know if you need more information. Thank you in advance 🤗

[v-tangjie-msft · Accepted solution]

Hi @Newbie22 ,

According to your description, you want to randomly assign cases to people,right?Here are my steps you can follow as a solution.

(1)With power query, add an index column to Table2.

(2)We can create measures.

Measure = 
    RANDBETWEEN(MINX('Table (2)',[Index]),MAXX('Table (2)',[Index]))

Measure 2 = 
Lookupvalue('Table (2)'[Resource Name],[Index],[Measure])

(3)Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Newbie22]

Hello @v-tangjie-msft , thank you so much it worked 😊 Really appreciate your support on this. Have a nice day! ❤️

[Newbie22]

Up 😊