Forum Discussion
Solved
Problem dealing with date type from different locations
Hello community, I am dealing with a Power BI than integrates data from different excels files hosted in a sharepoint. The issue comes from the date type, as sometimes Power BI captures it like "...
Thank you guys!
I ended up doing a super loooong cleaning, splitting by delimiters, and then joining again 🙂
Not the most elegant solution... but for now it works:)
Hi Victormar
Yes, Here are some YouTube videos that can help you handle different date formats while loading Excel files into Power BI: It may bw helpfull for you.
https://youtu.be/cPYNYOJAD3Q?si=6yr2FjgOQ9HSo_1P
https://youtu.be/hehYMb9kobw?si=YEK3ZjBFmAraR_mn
https://zebrabi.com/guide/how-to-change-date-format-in-power-bi-visual/
Thanks!