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 taking lot of time as i have over 5000 rows.
1. I have a list of handlers who are to be audited for the respective date.
2. i have the list of auditors who are available to audit the handers auditors numbers will changing every day depends on the availability.
3. The end result which i am expecting here is something like below
Example for 01st May 2022 i want to assign available Auditors(03 in number) randomly to the 01st May Available Handlers (09 in number)
Not sure if this is possible in Power BI or not but if any help is much appreciated as this can save a lot of manual Hrs to me
Regards,
Kiran
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
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 |
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
