Forum Discussion

Fazelmann's avatar
Fazelmann
New Member
1 year ago
Solved

Issue with date format conversion

Date conversion fails for text DD.MM.YYYY when using Swedish locale (sv-SE), but works with German locale (de-DE). Data has been validated with Trim, Clean, and character code analysis. Data from exc...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    1 year ago

    Hi Fazelmann ,
    Please try using In, the simplest fix is to always use Change Type With Locale → German (Germany) for DD.MM.YYYY formatted data, then your dates will reliably convert to the proper YYYY-MM-DD format inside Power BI.

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

    🔗 Curious to explore more? [Discover here].

    Let’s keep building smarter solutions together!

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
1 year ago

Hi Fazelmann ,
Please try using In, the simplest fix is to always use Change Type With Locale → German (Germany) for DD.MM.YYYY formatted data, then your dates will reliably convert to the proper YYYY-MM-DD format inside Power BI.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!