Last seen: Aug 24, 2025
Oops, I did it again! Here it is.
Any reason why you must do this in PQ? Otherwise it's quite easy in Excel with a list dates and a pivot table. See attached example that has dates for...
I would do that with a small lookup table as demonstrated in the attached file.
OK, that makes everything clear. See attached! I'm not particularly proud over the query as it is rather crude and I believe there must be a better...
I see my query is not giving the results you expect, but I still don't understand the logic. Sorry. Let me explain why. Customer 17, Item A has thr...
Still not sure what you mean. I didn't buffer a table, though connected to two tables in one query.
See attached! Though still not sure I understood all. How do you define an overlap? Perhaps I'm just slow today 🙂
OK! Thanks for the file. But I don't understand the logic of what you wan to do. You say that there are overlapping periods for items with the same ID...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Don't understand what you mean by Its like #"Buffered".
Sorry, but I can't replicate that behavior. I connect to the CSV, set the correct date format and all dates remain in the file. Perhaps you can upload...
Nothing wrong with this file. All April dates are in it and I can get them into Excel and PQ without issues. You wrote that you open the CSV in Ex...
Perhaps difficult to explain, but you have to connect to both tables (Source and Source2). Then merge them (left anti join) to find the rows that are ...
Glad I could help!
The attached file contains two possible PQ solutions. One is rather crude but works just fine and is easy to follow. The other is a bit more advanced,...