Forum Discussion
Solved
Find first values per ID and earliest Date
Hi All, I am attempting to retrieve the earliest record for several data points within my table per ID. The bolded lines in the data below is what information I am interested in. I want to put th...
Hi An_dy
To perform the filter you are interested in.
In the first step, you can add a ranking column to your data table.
In order of date, rank each ID
DAx formula ;Ranking = RANKX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[DOS],,ASC)You filter the table by the column you added when you display it. The value of 1
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ritaf1983
Super User
Super UserHi An_dy
To perform the filter you are interested in.
In the first step, you can add a ranking column to your data table.
In order of date, rank each ID
DAx formula ;
Ranking = RANKX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[DOS],,ASC)
You filter the table by the column you added when you display it. The value of 1
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
