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]
2 Replies
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!
