Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
Is there a way to change date format to this column? or there is a better way to do it.
Thanks to help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
You should be able to convert text formatted date's to dateTime without any issue so there is something trong with the text. It might be that it's the wrong delimiters or that there are other blankspaces present in the date. If you provide an image of the dates I might be able to see if there are any issues directly.
Otherwise what you can do if you really can't get it to work is splitting the text column up in year, month and date and use this custom column to create a date: (Make sure that all three columns are formatted to whole number)
For original post you may refer to:
Solved: DataFormat.Error: We couldn't parse the input prov... - Microsoft Power BI Community
Solved: We couldn't parse the input provided as a DateTime... - Microsoft Power BI Community
Best regards.
Community Support Team_ Caitlyn