Getting earliest date field when someone is available

[Anonymous]

Hi Everyone,  first time posting and I really love the tool. 

  I'm trying to pull a value from a table to see the earliest date someone is available?  I would I go about doing this?

Thanks for everyone's help!

[mmace1 · Accepted solution]

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. 

[Vvelarde · Accepted solution]

@Anonymous

Hi, One way without DAX is:

Regards

Victor

Lima - Peru

[Ashish_Mathur · Accepted solution]

Hi,

Try this Measure

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

Hope this helps.

[Vvelarde · Accepted solution]

@Anonymous

Hi, One way without DAX is:

Regards

Victor

Lima - Peru

[mmace1 · Accepted solution]

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.