Forum Discussion
Solved
Quarterly Report- Select First Entry
I need to create a quarterly report that scans a SP list and counts an contact as new if it is the first entry in a designated time period. For Example: If I create a slicer with a begin and end ...
Hi slhangen
You can add a calculated column, which will rank the entries by date.Count_times = RANKX(FILTER('Table', 'Table'[Id]= EARLIER('Table'[Id])),'Table'[date],,ASC,DENSE)and then use a simple dax for measure with filtering first entry only
First entries = CALCULATE(DISTINCTCOUNT('Table'[Id]),'Table'[Count_times]=1)pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
