I currently have a column that is created using the following DAX formula which indicates if the listed activity is the first one ever for that Entity ID
:
First Time Activity =
if('Activity Table'[Timestamp]=
CALCULATE(min('Activity Table'[Timestamp]),
filter('Activity Table',
'Activity Table'[Entity ID] = earlier('Activity Table'[Entity ID]) &&
'Activity Table'[Activity Name] = earlier('Activity Table'[Activity Name])
)
)
,1,BLANK())
But I need this now to be a column made in PowerQuery instead of DAX. Any help on the PowerQuery formula would be much appreciated.
Thanks