Approximate Date Match with Multiple Criteria

Hi Jihwan_Kim ,

My apologies for the confusion as I just realized I did not use the same name in my DAX calculated column as I did in the "Contract" table. 

For clarification, the column titled "Contract Expired On" DOES NOT currently exist in the "Contract" table. This is the column I am trying to write DAX for. The screenshot of my DAX code in my previous post should have started off with "Contract Expired On = IF(" instead of "Mileage Exceeded = IF("

In the code you sent back, the variable on Line 4 cannot be derived as the column name "Contract Expired On" does not yet exist....again, this is what I'm trying to derive. 

The highlighted values in the "Contract" table are the results I am expecting to get from the DAX formula (i.e. the contract expires on the date when the "Mileage" in the "Usage" table is greater than or equal to the "Contract Ending Mileage" in the "Contract" table.

Hopefully, this clears it up!

Best regards!