Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Min of multiple dates

Hello Every one    I need to take the min hour in some colums, but some of them are null, so when i use the min expression takes the null value as the min, so i need to evaluate only the rows wich ...
  • Zubair_Muhammad's avatar
    7 years ago

    Anonymous

     

    USe this Calc column

     

    Min =
    VAR temp = { [Bloq_Entrega], [Bloq_credito], [Bloq_comer] }
    RETURN
        MINX ( FILTER ( temp, [Value] <> BLANK () ), [Value] )