Forum Discussion

smedina1's avatar
smedina1
Frequent Visitor
3 years ago
Solved

MIN.SI.CONJUNTO IN POWER BI

  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 bel...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
wdx223_Daniel
Community Champion
3 years ago

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

  • Bonilla2110's avatar
    Bonilla2110
    New Member
    2 years ago

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

    Saludos