Hi, I have a table that looks like this:
|Order ID||Link ID||Order Date||Order Status|
Each Link ID can have multiple Order ID's. What I'm trying to do is look up Orders based on the Link ID, and return the Max of Order Date, and that Max Order Date's corresponding Order Status. Like Below (Link Date and Link Status):
|Order ID||Link ID||Order Date||Order Status||Link Date||Link Status|
I was able to work out the Link Date DAX formula, but I'm unable to fetch it's corresponding Link Status.
FILTER((Table), Table[Link ID] = earlier(Table[Link ID]))
How do I get the corresponding Order Status for the Link Date?
Any help is appreciated.
Edit: I goofed up the formatting, but here's a clearer picture