Getting earliest date field when someone is available

You could pull a version of the table where you:

Filter to only Available = yes

Group on name, by the min of the Period. 

Here's an example on one of my queries just to show where these options are. 

Anonymous

Hi, One way without DAX is:

Regards

Victor

Lima - Peru

Hi,

Try this Measure

=CALCULATE(MIN(Data[Period]),Data[Available]="Yes")

Hope this helps.