Forum Discussion

Miguel123's avatar
Miguel123
Frequent Visitor
3 years ago
Solved

PRIMERA FECHA SI ES MAYOR A OTRA

Saludos,   Como hago para me salga la min(fecha) si se cumple la primera columna. Osea yo quiero la primera fecha de 1raFacturas, despues de la fecha de 1raTransferencia.    
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Miguel123 ,

     

    Do you want to get the first 1raFactura after 1raTransferencia ?

    I suggest you to try code as below.

    First Date 1raFacturas after 1raTransferencia =
CALCULATE (
    MIN ( 'Table'[1raFactura] ),
    FILTER ( ALL ( 'Table' ), 'Table'[1raFactura] > 'Table'[1raTransferencia] )
)

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Miguel123 ,

 

Do you want to get the first 1raFactura after 1raTransferencia ?

I suggest you to try code as below.

First Date 1raFacturas after 1raTransferencia =
CALCULATE (
    MIN ( 'Table'[1raFactura] ),
    FILTER ( ALL ( 'Table' ), 'Table'[1raFactura] > 'Table'[1raTransferencia] )
)

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.