Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I use data that come from SQL tables where date is recorded as a 16 character date/time text string.
This is an example of one - 20210630192455
I want a simpler way of converting this to date time than I am currently doing. It initially appears in my table as Text. If I just change the data type to Date/Time it errors with the error being it cant parse the date/time. Right now I do the following;
I then have to rename all my columns.
Solved! Go to Solution.
Hi,
This calculated column formula in DAX should work
Date = date(left(Data[String],4),mid(Data[String],5,2),mid(Data[String],7,2))
Hope this helps.
Hi,
This calculated column formula in DAX should work
Date = date(left(Data[String],4),mid(Data[String],5,2),mid(Data[String],7,2))
Hope this helps.
Thank you, I will give it a try. I was hoping to have something in Power Query but this is a start.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
87 | |
77 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |