Forum Discussion

Bansi008's avatar
Bansi008
Helper III
2 years ago
Solved

How to calculate minimum date based security column.

Hi there, Can someone please help me here to calculate the minimum date in a separate column based on the security column.    sample input data:-  SECURITY DATE Amazone 6/30/2024 Flipk...
Need Help
  • Irwan's avatar
    Irwan
    2 years ago

    hello Bansi008 

     

    please check if this accomodate your need.

    MIN_DATE =
    MINX(
        FILTER(
            'Table',
            'Table'[SECURITY]='Table'[SECURITY]&&
            'Table'[DATE]<=EARLIER('Table'[DATE])
        ),
        'Table'[DATE]
    )

     

    Hope this will help you.

    Thank you

Irwan's avatar
Irwan
Super User
2 years ago

hello Bansi008 

 

please check if this accomodate your need.

MIN_DATE =
MINX(
    FILTER(
        'Table',
        'Table'[SECURITY]='Table'[SECURITY]&&
        'Table'[DATE]<=EARLIER('Table'[DATE])
    ),
    'Table'[DATE]
)

 

Hope this will help you.

Thank you

Bansi008's avatar
Bansi008
Helper III
2 years ago

Irwan thank you this is helpful

  • Irwan's avatar
    Irwan
    Super User
    2 years ago

    Hello Bansi008 

     

    Glad to be a help.

     

    Thank you.