Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am trying to create a date table based on this date format: Tue Mar 27 10:33:09 CST 2018. This is downloaded from a CISCO platform.
I tried creating a new column and then adding a MID - CONCATENATE formula. The date is shown as text and looks like this : 01 Mar 2018 but when I tried to format it to an actual date, it gives me this error: Cannot convert value '' of type Text to type Date.
Also, I tried to do something similar to extact the hour but no luck.
Any help will be highly apreciated.
Solved! Go to Solution.
I got the solution, I was able to break the date in the query section and then extract the hour.
It would had been good to notice it before posting this question, though lol.
I got the solution, I was able to break the date in the query section and then extract the hour.
It would had been good to notice it before posting this question, though lol.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |