Help with Adding a Month to a Date Column

[swaggerboy69]

Hi Team,

So I have a date column but I have to create another column that would add 1 Month to it.

I used the query:  PlannedDPdate = DATEADD(Query1[WIP MMYY],1,MONTH)

But it's not creating all the dates.

See screenshot below.

Thanks!

[mahoneypat · Accepted solution]

It is probably missing dates that are not in your Date table, since DATEADD is a time intelligence function.  You can use EOMONTH or EDATE instead.  Those return dates and not date tables.

Regards,

Pat

[Anonymous]

Did you use add calculated column in power bi desktop ?

Or did you stuff it in power query and did a union after this ? 

We need to see where and how you did this

[swaggerboy69]

I used the calculated column