MIN.SI.CONJUNTO IN POWER BI

[smedina1]

Good afternoon,

I would like to know how I can apply this formula "min.si.conjunto" in power bi with DAX formule, in order to find the earliest date of a data record, as shown in the image below.

Thank you 😄 

[v-cgao-msft · Accepted solution]

Hi @smedina1 ,

Please new a calculated column like:

Earlist Order Date = 
CALCULATE (
    MIN ( 'Table'[Order Date] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Order Number] = EARLIER ( 'Table'[Order Number] )
    )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[wdx223_Daniel]

CalculatedColumn=MINX(FILTER(Table,Table[Order Number]=EARLIER(Table[Order Number])),Table[Order Date])

[Bonilla2110]

Gracias. pasé 1 hora buscando la solución y aca  estaba.

Saludos