Forum Discussion
Randomizer allocation of Data
Hi Expertise, i need your help to allocate the Quality Auditors to handlers. either it can be through power Qery or with DAX function on Power BI Desktop. i tired doing it in excel but it is taki...
Updated pbix uploaded to https://1drv.ms/u/s!Akd5y6ruJhvhuWhgv10sl6bguDbP?e=z99tuN
Yes, I had forgotten to replace 3 with List.Count(ListOfAuditors).
The file has been uploaded to https://1drv.ms/u/s!Akd5y6ruJhvhuWXwAK0Dh1u8P3W3?e=vJ6LJM
Hi Vijay,
That was really helpful thank you so much.
Now i wanted to assign available Auditors to Handlers with the combination of Date and Product
Example the avilable Auditors for 1sth May with Product "MT Motor" has to be assigned to 1st May Handler with "MT Motor"
the Logic of assigning Auditors remain same but it has to be a combination of Date and Product.
Sample Data for your reference:
| Date | Handlers | Product |
| 5/1/2022 | Ebrahim Abrahams | MT Motor |
| 5/1/2022 | Kayla Adamson | MT Motor |
| 5/1/2022 | Zeenat Ally | MT Motor |
| 5/2/2022 | Thimna Rapiya | MT Motor |
| 5/2/2022 | Fadwa Rasdien | MT Motor |
| 5/1/2022 | Thomas Faragher | Affinity Home |
| 5/1/2022 | Rob Hall | Affinity Home |
| 5/2/2022 | Angela Holman | Affinity Home |
| 5/2/2022 | Saffron Jordan | Affinity Home |
| 5/2/2022 | Keith Lakeman | Affinity Home |
| 5/3/2022 | Vera Potter | Affinity Home |
| 5/3/2022 | Rachel Robinson | Affinity Home |
| 5/1/2022 | Leigha Powley | JL Home |
| 5/1/2022 | Mohammed Qasam | JL Home |
| 5/1/2022 | Jill Smith | JL Home |
| 5/2/2022 | Cynthia Steadman | JL Home |
| 5/2/2022 | Umarah Tariq | JL Home |
| 5/2/2022 | Isabelle Whitehead | JL Home |
| 5/3/2022 | Mark Browell | JL Home |
| 5/3/2022 | Enola Clish | JL Home |
| Date | Auditors | Product |
| 5/1/2022 | Pooja Raut | MT Motor |
| 5/1/2022 | Shanthi Vijayaraghavan | Affinity Home |
| 5/1/2022 | Vasudev Murthy | MT Motor |
| 5/1/2022 | Shivanand Kadakol | JL Home |
| 5/1/2022 | Bindushree Panduranga | JL Home |
| 5/1/2022 | Daphne D'Silva | Affinity Home |
| 5/2/2022 | Meghna Gaurishankar Gaud | JL Home |
| 5/2/2022 | Nanditha Panduranga | MT Motor |
| 5/2/2022 | Naveen Kumar | Affinity Home |
| 5/2/2022 | Nikitha Manjunath | JL Home |
| 5/2/2022 | Deepika Anish | Affinity Home |
| 5/3/2022 | Keerthi Kumar | MT Motor |
| 5/3/2022 | Kushmanjali Ramachandra | Affinity Home |
| 5/3/2022 | Maria Harry | MT Motor |
| 5/3/2022 | Meena Kumari | JL Home |
| 5/3/2022 | Touseefa Naaz | JL Home |
| 5/3/2022 | Yashas Raaj | Affinity Home |
Updated pbix uploaded to https://1drv.ms/u/s!Akd5y6ruJhvhuWhgv10sl6bguDbP?e=z99tuN