Forum Discussion
webportal
5 years agoImpactful 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.
- 5 years ago
webportal , I think you should be able to get date like
date(1970,01,01) +[col]
or
date(1900,01,01) +[col]
amitchandak
5 years agoSuper User
webportal , I think you should be able to get date like
date(1970,01,01) +[col]
or
date(1900,01,01) +[col]