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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Find out where you can attend!