Forum Discussion
Solved
DAX - Date before
I am attempting to pull the date of the 101 Movement type that comes directly before a 102 movement. I have no issues determining the Max date for an order # by movement type however cannot for t...
Create a measure with:
a variable that holds the date of the type = 102 record-> _102Date
Return the largest date from the filtered table of type = 101 and PostingDate < _102Date
Is this going to be a measure or a calculated column? And if a measure, then what will happen if there are many different orders visible in the context? How to decide which date to return?