Forum Discussion
Merge by condition and approximate matching in Power Query
Hi community! I have got a question. We have got clients, who do orders, and managers, who control orders. The final goal is to understand, which manager provide what volume of orders. But, during ...
I don't know if that's exactly what you're looking for (in the sense that being simple and "better" at the same time isn't common).
At least the functions you mentioned and which, for some reason, did not satisfy you are not used.
edit:
This solution assumes that the Change date manager table is sorted in ascending order.
Otherwise it can be easily adapted to the generic case.