Forum Discussion
Solved
Find earliest Date from column with possible repeated row value
Hi All, I would really appreciate any DAX help I can get with this. I am trying to create a calculated column that finds the first date when the "Goal Met" column shows "completed" or in other word...
It works when I add dummy ID to your sample data :smileysurprised:
Please see the pic below
Zubair_Muhammad
Community Champion
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!!