Forum Discussion
Solved
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.
webportal , I think you should be able to get date like
date(1970,01,01) +[col]
or
date(1900,01,01) +[col]
It is 1.1.1900
🙂
Thanks!