Forum Discussion

Monicam's avatar
Monicam
Frequent Visitor
5 years ago
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...
  • HotChilli's avatar
    HotChilli
    5 years ago

    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

     

     

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

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