Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
BárbaraBraga
Regular Visitor

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 is changed to 3 July 1905. How do I solve this problem? Because I need to create some measures using date formulas.
1 REPLY 1
vicky_
Super User
Super User

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.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.