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.
Hi,
I am getting error when I change the data type to date/time/zone.
Input data has values like mm-dd-yyyy hh:ss:mm timezone. When I change the data type to time-zone its giving error. Please advice.
Attaching samples images.
Solved! Go to Solution.
Hi @Anonymous
First split column
Then add a custom column
Custom= #datetimezone(Date.Year([#"date-act.1"]),Date.Month([#"date-act.1"]),Date.Day([#"date-act.1"]),Time.Hour([#"date-act.1"]),Time.Minute([#"date-act.1"]),Time.Second([#"date-act.1"]),-7,0)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
First split column
Then add a custom column
Custom= #datetimezone(Date.Year([#"date-act.1"]),Date.Month([#"date-act.1"]),Date.Day([#"date-act.1"]),Time.Hour([#"date-act.1"]),Time.Minute([#"date-act.1"]),Time.Second([#"date-act.1"]),-7,0)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could you click on one of the errors and confirm what is the error message? It could be the records that are not a valid date time.
Regards,
Tarun
Hi
Will there any option to correct this.
Error pic attaching intoquestion section.
Looks like an issue due to the time zone designator in the data.
If PDT or PST is not necessary, you may try removing the last 3-4 characters from your date column and then parse the date.
If the timezone is required, you may try extracting the timezone characters from the date and replace those with the hours:minutes to be adjusted (+ -) and then combine the two to get datetimezone.
Regards,
Tarun
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |