I spent 45 mins with ChatGPT trying to give me the quick resolve for something querying with M.
It ended with me telling ChatGPT that if it worked for me, it would be fired because it kept trying to reoptimise my query, resulting in syntax and load errors, then “fixing” them by ignoring my query’s criteria.
I ended up going old school and taking an extra 30 mins to just figure it out myself. Now that I know how it’s done, it’s surprisingly easy to understand.
So I took that as a compliment; or ChatGPT just sucks at PowerQuery.
It probably learned, though. If anyone has transform queries around multi-level filtering criteria and ChatGPT helps, that’s because of my suffering.