Forum Discussion
Power Query - Date error after filtering (but not before)
Step 1: Lie down
Step 2: Try not to cry
Step 3: Cry a lot.
I managed to fix it though, I copied the exact M code from the other 3 tables that used almost identical Excel tabs (they had one or two extra steps that did redundant things like removing unrelated columns etc) and it magically decided to cease torturing me.
Thanks for your help regardless!
Jake
Hi Icey,
I'm not sure why you can't access as the file is set to public view:
Here is the result from checking 'Column Distribution':
Thanks!
Hi Anonymous ,
Sorry, my mistake. I can access it. And in your scenario, only "Column quality" option is needed to check. With this feature, we can find if there is any errors. "Column distribution" is not needed, which provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns.
Back to the topic. I have tested with the file you shared, but can't reproduce your issue. It works on my side. Could you check if there is really nothing wrong in the previous step?
Best Regards,
Icey
Step 1: Lie down
Step 2: Try not to cry
Step 3: Cry a lot.
I managed to fix it though, I copied the exact M code from the other 3 tables that used almost identical Excel tabs (they had one or two extra steps that did redundant things like removing unrelated columns etc) and it magically decided to cease torturing me.
Thanks for your help regardless!
JakeHi Anonymous ,
Glad to here that the issue has been solved. Please accept your reply as the solution.
Best Regards,
Icey