Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |