Forum Discussion
Find earliest Date from column with possible repeated row value
It works when I add dummy ID to your sample data :smileysurprised:
Please see the pic below
Thank you for the quick responses.
One thing I forgot to mention is that the table includes multiple IDs and multiple lines for each ID, so using FIRSTNONBLANK like you all suggested gives me the earliest date of the first time the row with "completed" happened, so if I want to filter and look at a specific ID they all end up having the same "date of Goal met".
I need the earliest date for each unique ID. Does that make sense?
Thank you again!!
Community Champion
Give this a shot
Date of Goal Met =
VAR First_Date =
CALCULATE (
FIRSTNONBLANK ( Table1[Date], 1 ),
FILTER ( ALLEXCEPT ( Table1, Table1[ID] ), Table1[Goal Met] = "Completed" )
)
RETURN
IF ( Table1[Goal Met] = "Completed", First_Date )Thanks Zubair,
That's still not giving me the Date for each ID, it populated all the ID's with the same date which is the earliest first occurence of "Completed".
Reading your formula it makes sense that it would work but there's something missing that I can't seem to figure out.
- Zubair_Muhammad
It works when I add dummy ID to your sample data :smileysurprised:
Please see the pic below
wow that's great, thank you Zubair!
I think my issue is with the data, I need to dig deeper, but this will work!
Thank for taking the time to help me!!