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

[DavidNunes7]

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:

Thanks 

[TomMartens · Accepted solution]

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:

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

[DavidNunes7]

Great solution!!!!
Thank You 😁