Forum Discussion
Solved
Power Query - Join/Merge based on Date between 2 dates
Hi, I have two tables, a period table and a sales table. I need to use the invoice creation timestamp on the sales table and assign the week number from the period table where the timestamp is betwe...
Hi there,
there is actually a pattern for this task that will probably increase speed: https://www.skillwave.training/vlookup-true-in-power-query/
Also see attached file.
It delivers correct results if the intervals are without gaps like in the data pedanticpad gave in his initial thread.
Hi there,
there is actually a pattern for this task that will probably increase speed: https://www.skillwave.training/vlookup-true-in-power-query/
Also see attached file.
It delivers correct results if the intervals are without gaps like in the data pedanticpad gave in his initial thread.
