Help with the DAX Measure- Fill time !

[Anonymous]

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!

[v-chuncz-msft]

@Anonymous 

You may use MINX and try the DAX pattern in post below.

https://community.powerbi.com/t5/Desktop/Fiiltering-table-visualisations-I-need-quot-AND-quot/m-p/602714#M286833

[Anonymous]

Thanks! Will try it out now!

[Ashish_Mathur]

Hi,

Show the exact result you are expecting there with an explanation.

[Anonymous]

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.

[Ashish_Mathur]

Sorry I just cannot understand.  Someone else will help you.