Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with Adding a Month to a Date Column

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!

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I used the calculated column

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    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