Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
Proud to be a Super User!
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |