date format in the original data source is text format as shown below .
I want to convert it into US date format as date type. It returns error : (even though I use the change the data type (local)
DataFormat.Error: We couldn't parse the input provided as a Date value.
Solved! Go to Solution.
If you go into the Query Editor, and click on the drop down for your Date column there is an option to say "Using Locale"
If for some reason your PC is set to a different Locale, the other option I can select is to split your column by the "/" delimiter, which will then create 3 columns for Day, Month & Year and then recreate the column by using the Columns from Example in the format you need. And then you can change the data type to Date.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!