PRIMERA FECHA SI ES MAYOR A OTRA

[Miguel123]

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.

[v-rzhou-msft · Accepted solution]

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.