DATEADD - problem of link between 2 tables

[pachi]

Dear all,

I am starting with Power BI and I would need your help on the function DATEADD.

I have well understood this is a time intelligence and my dates need to be somewhere to appear.
So I created a date table (marked as date table )

I my main table I would like to do:
- add 2 months to my column "Initial Receipt Date" (meaning if Initial Receipt Date = 01/Jan/2023, I would like to see 01/Mar/2023 in the column "2nd DD" -> without taken into account the number of days in the month)
I used the formula: 2nd DD = DATEADD('Line Listing 1'[Initial Receipt Date],2,MONTH)

I linked both tables by 'Line Listing 1'[Initial Receipt Date] & 'Dim Initial Receipt Date'[Date], however it doesn't work.
I probably made something wrong but I don't know what

Would someone be able to help me?

Thanks in advance for your help!

[FreemanZ · Accepted solution]

hi @pachi 

try like:

2nd DD = EDATE('Line Listing 1'[Initial Receipt Date],2)

[pachi]

Thank you so much for your help, this is exactly what I wanted to do!

[FreemanZ]

glad to hear that.

p.s.

you see, Time Intelligence functions are powerful, but may not always be necessary. Plain funtions like EDATE, EOMONTH are good enough in many date calculations.