Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi Team, I know there are many examples out there to look though but my example is not the same in terms of converting time which is in text data type to 24 hours time data type. Please see screenshot below. Any help would be appriciated.
Solved! Go to Solution.
In your query, replace "." with "" and then convert to type Time. This will show as am/pm, but you can load the data and then change the time format to 24-hour time.
Pat
In your query, replace "." with "" and then convert to type Time. This will show as am/pm, but you can load the data and then change the time format to 24-hour time.
Pat
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 4 | |
| 4 |