Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
5 years ago

How to Convert Number to Date

hi all ,    i have around 300 Excel File to be imported as Folder in Power BI ,  In each excel those are in date Format , when i import into Power BI , it turns out to Number instead , and i tryna...
Show and Tell
Chanleakna123's avatar
Chanleakna123
Post Prodigy
5 years ago

Hi , amitchandak  PhilipTreacy , my

file imported in BI , appeared to hve some row Sync  as date and some sync as serial number. 
omce I convert to date , the serial might be error. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Chanleakna123,

Perhaps you can try to add a new column on the 'query editor' side to store date value who transforms from the serial number, then you can use both of two type of values at the same time.

    #"Added Custom" = Table.AddColumn(#"Changed Type", "Date", each Date.AddDays(Date.FromText("1/1/1960"),Number.From ([Delivery Date] )))

Regards,

Xiaoxin Sheng