Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Our company is global and my projects come in from a variety of regions. Up until this point I've been pretty lucky in that the date formats i've been working with him have little endian (DD/MM/YYYY), which matches my computer's regional settings. I've just started on a newer project, where my data source uses middle endian dates (MM/DD/YYYY).
Is there a way that i can specify the date format of data within Power Query rather than having it always use my regional date format? My current solution has been to treat the date as text and parse it into multiple columns, then re-combine myself. It feels clunkier than it needs to be.
Solved! Go to Solution.
You can transform your text dates to real dates, using a culture code (or Locale).
The pictures apply to numbers, but you can apply this similarly to dates.
You can transform your text dates to real dates, using a culture code (or Locale).
The pictures apply to numbers, but you can apply this similarly to dates.
Thanks! I don't know how i missed such an obvious option.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |