Forum Discussion
Month column not properly formatted
Hi, I have monthly data imported for 10 months from 10 excel sheets from which the Month was extracted from the file names using "Text between Delimiters", the data type of the Month column is te...
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
I tried to reproduce your issue, but it failed.It works as expected.
Can you share some screenshots and M query code?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi V-lianl-msft ,
PFA the sample pbix along with the sample data files with the file names similar to how it actually is.
https://drive.google.com/file/d/1jyfzuN5JNOhju2qAkZNiH17uGwvSRrEg/view
I am facing the same issue above where the Dec19 (i.e. Dec 2019) file name gets converted to Dec20 when I change the data type to Date.
Let me know if you have any questions.
Thanks,
Vishy