Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query - Date error after filtering (but not before)

Hello, I am receiving the following error when trying to filter a date column to only include dates up to and including last month: "DataFormat.Error: We couldn't parse the input provided as a Da...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Glad to here that the issue has been solved. Please accept your reply as the solution.

 

 

Best Regards,

Icey