Capture first date in a state but not any subsequent dates

[Anonymous]

What I want is to capture the FIRST DAY that a work item is in the state committed, but not any of the days after that it stays in the committed state. hopefully, the table below will help. 54118 earliest date is 10/23 and that's the only date I want to capture until it moves into another state.

Get Earliest Date =

FIRSTDATE(Burndown[DateValue])

Do I need to do a calendar function then a MIN(x)?

[Bifinity_75]

Hi @Anonymous , If I have understood the problem correctly, you need to create this measure:

First day = CALCULATE(min('Table (2)'[Date]),'Table (2)'[State]="Inprogress")

Where 'Table (2)' is the name of your table,

best regards