Forum Discussion

cbruhn42's avatar
cbruhn42
Icon for Helper III rankHelper III
2 years ago
Solved

Return Earliest Date/Time Based on Calculated Column

I have the data set below and I'm determining the 'in Spec' column by comparing the Amount to the spec limit in a related column.  The column titled 'Column' is trying to return the earliest DT when ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Your formula is not overly efficient but it returns the desired result

     

     

    Here is a slightly better alternative with better sample data

     

     

     

  • parry2k's avatar
    parry2k
    2 years ago

    cbruhn42 or try this:

     

    Earliest Date = 
CALCULATE ( 
    MIN ( 'Vessel'[DT] ),
    ALLEXCEPT ( 'Vessel', Vessel[VesselID] ),
    Vessel[in Spec] = 1 
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

cbruhn42 or try this:

 

Earliest Date = 
CALCULATE ( 
    MIN ( 'Vessel'[DT] ),
    ALLEXCEPT ( 'Vessel', Vessel[VesselID] ),
    Vessel[in Spec] = 1 
)
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Looks like your query plan is better with fewer estimated rows but somehow my version is faster.

    Edit: Never mind, I had not disabled the query cache.  Same run time, roughly.