Forum Discussion

webportal's avatar
webportal
Impactful Individual
5 years ago
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.
  • amitchandak's avatar
    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]