Display "Date" for first non blank cell value.

[StuartSmith]

I have been trying to get "FirstNonBlank" to work, but I cant and therefore asking for help.  I need a measure that will identify the first non blank row for each ID and then give the date of the first non blank row.  So as an example, ID 1 would be 03/01/2023, ID 1 would be 01/01/2023, and so on. How can this be done.

Thanks in advance

[DOLEARY85 · Accepted solution]

Hi,

based on your data you could try the below in a calculated column:

CALCULATE(MIN('Table'[Date]),ALLEXCEPT('Table','Table'[ID]),'Table'[Backfill]="Yes")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍