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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DavidNunes7
Helper I
Helper I

How to add an integer like year to a date column in table via DAX

Hello everyone, I need help with Dax syntax and measurements.

I currently have a table with a date column and an integer column that represents year I need to know how do I create a calculated column by adding the date with the integer

Example:

DavidNunes7_1-1667672845361.png

 

Thanks 

 
1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @DavidNunes7 , 

 

you can use the below DAX statement to create a calculated column:

New Column = 
var __year = YEAR( 'Table'[Date] )
var __month = MONTH( 'Table'[Date] )
var __day = DAY( 'Table'[Date] )
return
DATE( __year + 'Table'[Year] , __month , __day )

The result:

image.png

As calculated columns do not benefit from all the compression power of the Tabular model as natural columns are doing, I recommend creating this column using Power Query. You can use the below formula to add a custom column to your table using Power Query:

#date( 
    Date.Year( [Date] ) + [Year]
    , Date.Month( [Date] )
    , Date.Day( [Date] )
)

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom

 






Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @DavidNunes7 , 

 

you can use the below DAX statement to create a calculated column:

New Column = 
var __year = YEAR( 'Table'[Date] )
var __month = MONTH( 'Table'[Date] )
var __day = DAY( 'Table'[Date] )
return
DATE( __year + 'Table'[Year] , __month , __day )

The result:

image.png

As calculated columns do not benefit from all the compression power of the Tabular model as natural columns are doing, I recommend creating this column using Power Query. You can use the below formula to add a custom column to your table using Power Query:

#date( 
    Date.Year( [Date] ) + [Year]
    , Date.Month( [Date] )
    , Date.Day( [Date] )
)

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom

 






Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Great solution!!!!
Thank You 😁

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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