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 below.




Thank you 😄 

 

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

3 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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