Forum Discussion

Newbie22's avatar
Newbie22
Icon for Resolver I rankResolver I
3 years ago
Solved

Automatically assign resources to New tickets

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. Let's say for example: ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Newbie22 ,

     

    Create below columns on user table:

     

     

    cumulative_% = SUMX(FILTER(ALLSELECTED(User),User[User ID]<=EARLIER(User[User ID])),User[% of Distribution])+0

end = ROUNDUP(User[cumulative_%]*MAX('Case'[Index]),0)

start = MAXX(FILTER(ALLSELECTED(User),User[User ID]<EARLIER(User[User ID])),User[end])+0

     

     

    Then create below column to case table.

     

     

    assign to = CALCULATE(MAX(User[Resource Name]),FILTER(User,User[start]<'Case'[Index]&&User[end]>='Case'[Index]))

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Newbie22 ,

 

Create below columns on user table:

 

 

cumulative_% = SUMX(FILTER(ALLSELECTED(User),User[User ID]<=EARLIER(User[User ID])),User[% of Distribution])+0

end = ROUNDUP(User[cumulative_%]*MAX('Case'[Index]),0)

start = MAXX(FILTER(ALLSELECTED(User),User[User ID]<EARLIER(User[User ID])),User[end])+0

 

 

Then create below column to case table.

 

 

assign to = CALCULATE(MAX(User[Resource Name]),FILTER(User,User[start]<'Case'[Index]&&User[end]>='Case'[Index]))