Find min date ignore closed date

[Anonymous]

Hi Team,

Please help me out below

I am expecting Cat wise MinDate but Status is closed just we have to ignore the line item and only consider Open Status.

Thank you

@ Greg_Deckler @Fowmy

[Icey · Accepted solution]

Hi @Anonymous ,

Try to create a calculated column or meausre like below.

Columns:

MinDatebyCat_Column1 = 
CALCULATE (
    MIN ( 'Table'[Date] ),
    FILTER (
        'Table',
        'Table'[Cat] = EARLIER ( 'Table'[Cat] )
            && 'Table'[Status] = "Open"
    )
)

MinDatebyCat_Column2 = 
CALCULATE (
    MIN ( 'Table'[Date] ),
    FILTER ( ALLEXCEPT ( 'Table', 'Table'[Cat] ), 'Table'[Status] = "Open" )
)

Measure:

MinDatebyCat_Measure1 = 
CALCULATE (
    MIN ( 'Table'[Date] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Cat] = MAX ( 'Table'[Cat] )
            && 'Table'[Status] = "Open"
    )
)

MinDatebyCat_Measure2 = 
CALCULATE (
    MIN ( 'Table'[Date] ),
    FILTER ( ALLEXCEPT ( 'Table', 'Table'[Cat] ), 'Table'[Status] = "Open" )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I need "Result Column", Cat wise "min date" if status is "Open"

[SanketBhagwat]

Hi @Anonymous .

Can you please elaborate what exactly your requirement is or provide an expected output?

Regards,
Sanket