Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
Great solution!!!!
Thank You 😁
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |