Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi guys,
I am wondering if I can convert 7pm to 19:00:00 in Power BI.
I have a column of time with same format, which is required to be converted.
Thanks
Joyce
Hi, @Joycelu819 ;
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Joycelu819 ;
You could select date\time column then change the format to "dd/mm/yy hh:mm:ss". like below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Joycelu819 , Assume AM PM are last 2 digits
if(right([column], 2) = "PM", time(12+left([Column]), len([Column])-2,0,0), time(left([Column]), len([Column])-2,0,0))
@amitchandak Thanks for your answer. I tried to type this in the query bar, but it did not work. Did I do in a right way?
Joyce
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |