Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Assigning Rotating Shift Team based on Service Request Data

Hello, I'm trying to systematically assign event data (Service Requests) that are generated within my company. All service requests produce 1 row of data of about 10 attributes, (Service Request...
Need Help
Fowmy's avatar
Fowmy
Super User
4 years ago

Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Fowmy,

    Thanks for taking the time to try to help me with this. Below is some example data.

     

    The top one is a calendar lookup. Very simple, just has the data and the Team for each rotation based on the schedule (Blue, Green, Red, White are the teams). 2 teams alternate back and forth on nights with eachother and the other two alternate back and forth on days.

     

    The table below that is a very abreviated version of the Service Request data that we get. Essentially, each Service Request is made to get a Technician to respond and fix a piece of equipment. There are a lot more data columns in this data set, but it's not relevant for this discussion. So, what I'm trying to do is have Power BI automatically assign each Service Request (Job Number in bottom table) to the applicable rotating Ops Team, based on the Time & Day that the request was made (Create_Sched_Date in the bottom table).

     

    You asked if I want a Column or Measure, but to be honest, I'm not 100% sure. Of how I understand DAX and Measures and Columns, I think I want Measure Data.

     

    When all is said and done, I'd like to have a data variable (Ops Team) that I can use for filtering (i.e. show me all the Service Requests by each shift in a bar chart, or show me all how much total Minutes_Down, an attribute of every Service Requst, each shift has had.

     

    Hope all this makes sense. In my head, it's very simple in concept. In practice, I don't know how to make Power BI do this.

     

    Your help is much appreciated! Thanks!