Forum Discussion
Calculate difference in value between consecutive dates
Hi all, I have a table that looks something like this and I want to create a measure which will calculate the difference (NOT % difference) between similar rows but with the previous date. ...
Hello ERD
Your solution works.
But can you please let me know why you're using ISINSCOPE function in the Return query?
To me it worked fine even if I didn't write the Isinscope function.
Hoping for a reply.
Thank you.
PS: Just a curious learner of DAX.
It will make sure result is only shown when we have dates.
Here is more details on it: ISINSCOPE – DAX Guide