Hi
The original data file's Date column contains some data with 5 digital number like 44315. How to convert them into normal date format like 2021-09-13 in Power Query?
Thanks,

Hi
The original data file's Date column contains some data with 5 digital number like 44315. How to convert them into normal date format like 2021-09-13 in Power Query?
Thanks,

In Power Query, dates will be displayed according to your Windows Regional Settings short date format.
Since the original data appears to be "real dates" either formatted as yyyy-mm-dd or the unformatted `number of days since 1-Jan -1900, all you have to do in Power query is set the data type to type date:
Table.TransformColumnTypes(Source,{
{"Date", type date})
Source
M Code
let
Source = Excel.CurrentWorkbook(){[Name="Table11"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{"Date", type date})
in
#"Changed Type"
Results
I can't understand this part :
Source = Excel.CurrentWorkbook(){[Name="Table11"]}[Content]
all data should be transformed into Power Query Editor, right? Why the source is Excel table?
You can ignore that if it doesn't apply in your scenario. The important part is the date conversion, which you can do via the UI.
4 people are following this question.