Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with the DAX Measure- Fill time !

I have 2 tables:

Table A:

Table 2:

 

Column 1 is the linking column between tables.

Generally, there could be multiple assignments within each Requisition ID.

 

I'm looking to find:

The time to fill each requisition. For example if there are 3 assignments with each requisition - the time to fill is - the earliest time at which all the three assignments are working simultaneously.

If there is only one assignment within a requisition then the time to fill is the difference between the start date and the Job start date.

 

But the real problem arises if there are multiple assignments within a requisition.

 

Looking forward to your help.

Thanks

Anand!

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your reply.

      For example:

      If you use a slicer with the Req ID in Table A:

       

       for Req ID 1 ->The total positions is 1 -> so, the time to fill is (1/5/2019) - (1/1/2019)

       for Req ID 2 ->The total positions is  2 -> so, the time to fill is (2/4/2019) - (1/13/2019)

      (Here, 2/4/2019 is the date in which the two assignment workers are working simultaneously!

       

      So, depending on the total positions(T), the Req ID is the earliest time in which T number of assignments are working simultaneously.

       

      If an assignment ends before the start of the next assignment, we can't count that assignment.

       

      If this still isn't clear, kindly let me know so that I can make an even clearer definition.

       

      Thanks and looking forward to your replies.

       

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks! Will try it out now!