Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
jsaunders_zero9's avatar
jsaunders_zero9
Responsive Resident
4 years ago

Hi Kiran,

Can you share sample data in either excel or pbix? 

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    I don't find an option to attach the excel file hence copy pasting the data over here

     

    DateHandlers
    5/1/2022Adams, Ralph
    5/1/2022Akulis, Oskars
    5/1/2022Arif, Bilal
    5/1/2022Barnard, Ian
    5/1/2022Bellamy, Zara
    5/1/2022Bergmann, Caroline
    5/1/2022Bird, Shannon
    5/1/2022Brackenbury, Lisa
    5/1/2022Bradley, Neal
    5/2/2022Bridgewater, Ceri
    5/2/2022Calders, Kevin
    5/2/2022Chamberlain, Kathryn
    5/2/2022Chapman, Andrew
    5/2/2022Churchman, Jasmine
    5/2/2022Coleman, Sophie
    5/2/2022Adams, Ralph
    5/2/2022Akulis, Oskars
    5/2/2022Arif, Bilal
    5/2/2022Barnard, Ian
    5/2/2022Bellamy, Zara
    5/2/2022Bergmann, Caroline
    5/2/2022Bird, Shannon
    5/2/2022Brackenbury, Lisa
    5/2/2022Bradley, Neal
    5/3/2022Coultas, Ruby
    5/3/2022Cronin, Victoria
    5/3/2022Curtis, Ellie
    5/3/2022Dowell, Stuart
    5/3/2022Dublin, Jamie
    5/3/2022Fisher, Stephanie
    5/3/2022Flowers, Eleanor
    5/3/2022Frankish, Ann-Marie
    5/3/2022Frith, Susan
    5/3/2022Gay, Linda
    5/3/2022Hatcher, Alice
    5/3/2022Hibbs, Tracy
    5/3/2022Howe, Mollie

     

    DateAuditors
    5/1/2022Maria Harry 
    5/1/2022Vasudev Murthy
    5/1/2022Sumita Singh
    5/2/2022Shanthi Vijayaraghavan
    5/2/2022Pooja Raut 
    5/2/2022Bindushree Panduranga
    5/2/2022Meena Kumari 
    5/2/2022Daphne D'Silva
    5/2/2022Maria Harry 
    5/3/2022Vasudev Murthy
    5/3/2022Sumita Singh
    5/3/2022Shanthi Vijayaraghavan
    5/3/2022Bindushree Panduranga

    Regards,

    Kiran

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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