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 folks, might someone help me convert the below to a date\time\minute format?
I've tried it in Power Query with the below, but I'm getting an error:
= Date.From(Text.From([Date Hour and Minute], "en-US"))
Solved! Go to Solution.
Hey @MichaelHutchens ,
Here is the exact solution for your problem. Follow the article posted by me: Convert text type data/time column to date/time data type column (xplorebi.com)
Thanks,
Ajinkya K ( Analytics Specialist)
Hey @MichaelHutchens ,
Here is the exact solution for your problem. Follow the article posted by me: Convert text type data/time column to date/time data type column (xplorebi.com)
Thanks,
Ajinkya K ( Analytics Specialist)
Oh lawd it worked. I was just entering data incorrectly. Thanks so much @Ajinkya369 🙂
@MichaelHutchens , Try DateTime.FromText([Date Hour and Minute])
Or for only Date
Date.FromText(Text.Start([Date Hour and Minute],8))
pls try this
= Table.AddColumn(Source, "Custom", each #datetime(
Number.FromText(Text.Start([Date Hour an Minute],4)),
Number.FromText(Text.Range([Date Hour an Minute],4,2)),
Number.FromText(Text.Range([Date Hour an Minute],6,2)),
Number.FromText(Text.Range([Date Hour an Minute],8,2)),
Number.FromText(Text.Range([Date Hour an Minute],10,2)),
00))
Proud to be a Super User!
Hi @ryan_mayu , I'm getting this error:
I've verified that the field name is correct. Am I doing something wrong?
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |