Calculated Column grouped by Category and condition

[faint127]

Hey Guys

Im trying to create a Calculated Column (Calculated Date) that returns the last DateWithData, grouped by Product.

I can only manage to get min by Product

CALCULATE(min(Table1[DateWithData]), ALLEXCEPT(Product[ProductName]))

Any ideas?

Thanks in advance

[v-frfei-msft · Accepted solution]

Hi @faint127 ,

Here we go.

calculated date =
VAR currecntdate = [Data]
RETURN
    CALCULATE (
        MAX ( 'Table (2)'[datewithdata] ),
        FILTER (
            'Table (2)',
            'Table (2)'[Product] = EARLIER ( 'Table (2)'[Product] )
                && 'Table (2)'[Data] <= currecntdate
        )
    )

[Greg_Deckler]

Seems like you need something like this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814