add years to column

[anaorca1990]

hello i have a column that have diferrent dates and the next column has a number that represents that years i would like to the date.

i was trying to use a custome column with dax creating =dateadd(column a, column b, year) but is not working

column a = dates

column b = number of years to add.

thank you in advance for your help

[Nathaniel_C]

Hi @anaorca1990 ,

In Power Query, you can select Merge Columns on the Transform tab. Since you didn't provide pictures, I am assuming something like this.

Started with:

Then change type to text.

Then merge to columns with comma as delimiter.

Then changed name of column, and changed type back to date.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel