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
Hi Kiran,
Can you share sample data in either excel or pbix?
Thank you
Hi,
I don't find an option to attach the excel file hence copy pasting the data over here
| Date | Handlers |
| 5/1/2022 | Adams, Ralph |
| 5/1/2022 | Akulis, Oskars |
| 5/1/2022 | Arif, Bilal |
| 5/1/2022 | Barnard, Ian |
| 5/1/2022 | Bellamy, Zara |
| 5/1/2022 | Bergmann, Caroline |
| 5/1/2022 | Bird, Shannon |
| 5/1/2022 | Brackenbury, Lisa |
| 5/1/2022 | Bradley, Neal |
| 5/2/2022 | Bridgewater, Ceri |
| 5/2/2022 | Calders, Kevin |
| 5/2/2022 | Chamberlain, Kathryn |
| 5/2/2022 | Chapman, Andrew |
| 5/2/2022 | Churchman, Jasmine |
| 5/2/2022 | Coleman, Sophie |
| 5/2/2022 | Adams, Ralph |
| 5/2/2022 | Akulis, Oskars |
| 5/2/2022 | Arif, Bilal |
| 5/2/2022 | Barnard, Ian |
| 5/2/2022 | Bellamy, Zara |
| 5/2/2022 | Bergmann, Caroline |
| 5/2/2022 | Bird, Shannon |
| 5/2/2022 | Brackenbury, Lisa |
| 5/2/2022 | Bradley, Neal |
| 5/3/2022 | Coultas, Ruby |
| 5/3/2022 | Cronin, Victoria |
| 5/3/2022 | Curtis, Ellie |
| 5/3/2022 | Dowell, Stuart |
| 5/3/2022 | Dublin, Jamie |
| 5/3/2022 | Fisher, Stephanie |
| 5/3/2022 | Flowers, Eleanor |
| 5/3/2022 | Frankish, Ann-Marie |
| 5/3/2022 | Frith, Susan |
| 5/3/2022 | Gay, Linda |
| 5/3/2022 | Hatcher, Alice |
| 5/3/2022 | Hibbs, Tracy |
| 5/3/2022 | Howe, Mollie |
| Date | Auditors |
| 5/1/2022 | Maria Harry |
| 5/1/2022 | Vasudev Murthy |
| 5/1/2022 | Sumita Singh |
| 5/2/2022 | Shanthi Vijayaraghavan |
| 5/2/2022 | Pooja Raut |
| 5/2/2022 | Bindushree Panduranga |
| 5/2/2022 | Meena Kumari |
| 5/2/2022 | Daphne D'Silva |
| 5/2/2022 | Maria Harry |
| 5/3/2022 | Vasudev Murthy |
| 5/3/2022 | Sumita Singh |
| 5/3/2022 | Shanthi Vijayaraghavan |
| 5/3/2022 | Bindushree Panduranga |
Regards,
Kiran
Download your solution pbix for the queries.
Hi Vijay,
Thanks for your swift reply, when checked i see only 3 Auditors has been assigned to the Handlers every day. where in i have 3 Auditors for 1st May, 6 Auditors for 2nd May and 4 Auditors for 3rd May.
Is it something to do with Inserted Modulo in Handlers data?
Regards,
Kiran
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