I've read a blog by Alberto Ferrari saying that Earlier () should not be used and instead a variable should be created, but I cannot get it to work.
Here is the working code using Earlier to find the start date in the next row:
Go to Solution.
Try deleting the .[Date] in red font below
var CurrentCreatedOn = 'Workflow ActivityHistory'[CreatedOn].[Date]
var CurrentDocumentInstanceId = 'Workflow ActivityHistory'[DocumentInstanceId]
'Workflow ActivityHistory'[DocumentInstanceId] = CurrentDocumentInstanceId
&& 'Workflow ActivityHistory'[CreatedOn] > CurrentCreatedOn
View solution in original post
Removing .[date] worked, thank you. I didn't even notice that intellisense had added this.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!