Forum Discussion
Stuck on Date merge
Well I found a work around it seems.
I decided to join on just the categories and bring over the Start and End dates of the backconditions to the sales table that way. Conditional column on those dates and posting dates and voila I have what I need. Not a pretty solution, but I guess it will work for now.
Thanks for the input.
I think the first two options you've mentioned should work fine.
You've likely seen these articles already but just in case...
https://exceed.hr/blog/merging-with-date-range-using-power-query/
https://radacad.com/dates-between-merge-join-in-power-query
Depending on which option, disable load of queries that don't need to load or use Table.Buffer as mentioned in the 'exceed.hr' blog above.
Well I found a work around it seems.
I decided to join on just the categories and bring over the Start and End dates of the backconditions to the sales table that way. Conditional column on those dates and posting dates and voila I have what I need. Not a pretty solution, but I guess it will work for now.
Thanks for the input.
No problem.
Glad you have a working solution. 👍