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.
Hi, thanks for your reply. I agree it should work in theory, but it doesn't. I tried to load the query through the night, but this morning it was still stuck on 'creating connection in model'. My CPU and memory were both running at 95%, so I guess it must be an efficiency thing? I have all unneccessary queries on do not load. Only thing I haven't tried is Table.buffer, as in my experience it is a bit hit or miss. Will get back to you after I try it.