Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |