Calculated column to find lowest date with a filter on status value per ordernumber

nijos — Mon, 12 Feb 2024 20:09:08 GMT

I have this table with date, status and ordernumber.

For each OrderNumber, I want to find the first date that is on a row with status 30.

In a calculated column, that row must get a 1, the other rows should get a 0.

Thank you for your help on this.

Re: Calculated column to find lowest date with a filter on status value per ordernumber

nijos — Mon, 12 Feb 2024 20:30:14 GMT

Calculated Column =

VAR CurrentOrder = 'Table'[OrderNumber]

VAR FilteredTable =

FILTER ( 'Table', 'Table'[Status] = 30 && 'Table'[OrderNumber] = CurrentOrder )

VAR Result =

CALCULATE ( MIN ( 'Table'[Date] ), FilteredTable )

RETURN

IF ( Result = 'Table'[Date], 1, 0 )