Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Getting earliest date field when someone is available

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's avatar
    mmace1
    8 years ago

    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's avatar
    Vvelarde
    8 years ago

    Anonymous

     

    Hi, One way without DAX is:

     

     

    Regards

     

    Victor

    Lima - Peru

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this Measure

     

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

     

    Hope this helps.

3 Replies

  • mmace1's avatar
    mmace1
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    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's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous

     

    Hi, One way without DAX is:

     

     

    Regards

     

    Victor

    Lima - Peru

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Try this Measure

     

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

     

    Hope this helps.