Forum Discussion

ThisIsVS's avatar
ThisIsVS
Frequent Visitor
3 years ago

Change time format in power query.

How to change time in the "start" column of the following table to show only hours and minutes only.     For example, In the above image, time shown in the start column is "5:30:00" , What c...
Need Help
HotChilli's avatar
HotChilli
Community Champion
3 years ago

I think you are solving this problem in the wrong area.

You can format the column as 'short time' in powerbi desktop data view.

ThisIsVS's avatar
ThisIsVS
Frequent Visitor
3 years ago

HotChilli Sir, I'm using power query in excel, have to load this data to a table. Although, after loading data to a table, required result can be achieved but I am looking for a method(If there is) to achieve the required result in power query.