Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 the life of me determine how through DAX to pull the Maximum Date for Movement Type = 101 that comes before the 102 Movement Type. Below is an example of my data.
Thank you
Solved! Go to Solution.
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
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
User | Count |
---|---|
54 | |
48 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
42 | |
27 | |
22 |