Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |