Simulating an "approximate match" VLOOKUP in PowerPivot

It is often said that relationships in PowerPivot work in a similar way to VLOOKUPs. In reality, this is only partially true. If we examine the claim a bit closer we realize that Excel's VLOOKUP function has a parameter in which it is possible to use an approximation when matching values against the lookup table: