Forum Discussion
Solved
Join/Merge based on date between range AND ID (with condition ISNULL, fact.date)
Hi, I´ve stumbled upon a perculiar case where I need to JOIN two tables in Power Query between two dates and ID. In cases the support table endDate ISNULL i want to refer to the date in Fact =...
I think this is what your looking for (https://exceed.hr/blog/merging-with-date-range-using-power-query/ ).
In this blog post it's explained how to solve a similar problem. I think you can follow this instructions and get to the solution your looking for.
I think this is what your looking for (https://exceed.hr/blog/merging-with-date-range-using-power-query/ ).
In this blog post it's explained how to solve a similar problem. I think you can follow this instructions and get to the solution your looking for.
This worked liked clockwork big "+" with the optimized version.