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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
anaorca1990
Helper I
Helper I

add years to column

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

1 REPLY 1
Nathaniel_C
Super User
Super User

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:

 

dates combine.PNG

Then change type to text.

Then merge to columns with comma as delimiter.

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

 

dates combine1.PNG

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors