Forum Discussion

BárbaraBraga's avatar
BárbaraBraga
Regular Visitor
3 years ago

How to convert integer to date

Hello, I'm completely new to Power Bi. I have a column that should display the years in date format, however, they are in integer format. When I try to change the column type to date, the year 2011...
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

It depends. You can use the DATE(year, month, day) to convert integers to a date. Take a look at the docs here: https://learn.microsoft.com/en-us/dax/date-function-dax
I would recommend converting the integers to a date in Power Query, rather than doing it through DAX if possible though.