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
amitchandak's avatar
amitchandak
Super User
5 years ago

Chanleakna123 , One of the two should work

 

Delivery Date New = date(1970,01,01) +[Delivery Date]

or

Delivery Date New = date(1900,01,01) +[Delivery Date]