Date formatting on power query result

guignao

New Member
Joined
Jan 28, 2025
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello
Each time I actualize a power query I need to reformat dates column manually.
(New lines are not formated)
Did I miss something?
Thank you
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
I think that this is the way it is. I have not seen any way to make this export in date format.
 
Upvote 0
Solution
Hello
Each time I actualize a power query I need to reformat dates column manually.
(New lines are not formated)
Did I miss something?
Thank you
1- Make sure the column's data type in PQ transformation is a date/time data type before loading it into the worksheet. The resulting table should normally have the formatted column.
1738103225016.png

However, if it doesn't for some reason, then:
2- After loading data, move the mouse pointer over the table column header that you'd like to fix the format, and make sure seeing the black down arrow. Then right click and Format Cells. This way, the column should be formatted as you wish and new lines will obey that formatting as well (as long as the transformed data returns date values = the column's data type in the PQ is a date/time type).

1738102875094.png


Sample query:
Power Query:
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ30jcyMDJVitUBcUyQOWbIHENjBM8IWZ2xvqEpgmeibwjTFgsA", BinaryEncoding.Base64), Compression.Deflate)), {"Date"}),
    ChangeTypes = Table.TransformColumnTypes(Source,{{"Date", type date}})
in
    ChangeTypes

If it still doesn't work, then perhaps it might be helpful to see some sample data and your query to understand what I am missing.
 
Upvote 0

Forum statistics

Threads
1,226,267
Messages
6,189,940
Members
453,583
Latest member
Ok_category1816

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top