Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
webportal
Impactful Individual
Impactful Individual

How to convert Excel integer date to date

My date is a number in Excel-like format:

 

43957,96837

 

How to convert this into a date in "dd/mm/yyyy" format in Power BI?

 

Thank you.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@webportal , I think you should be able to get date like

 

date(1970,01,01) +[col]

or

date(1900,01,01) +[col]

View solution in original post

2 REPLIES 2
webportal
Impactful Individual
Impactful Individual

It is 1.1.1900

 

🙂

 

Thanks!

amitchandak
Super User
Super User

@webportal , I think you should be able to get date like

 

date(1970,01,01) +[col]

or

date(1900,01,01) +[col]

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.