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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |