Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DATEADD not working properly

Hi,

 

3M Start Date = DATEADD(tbl_IncentiveLatestDate[6M Start Date].[Date],3,MONTH)
this formula is returning blank even though my column is in proper date format
 
Dashboards
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    What result do you get with this calculated column formula?

    =EDATE(tbl_IncentiveLatestDate[6M Start Date],3)

  • Anonymous's avatar
    Anonymous
    7 years ago

    This worked for me:

    3M Start Date = EOMONTH(tbl_IncentiveLatestDate[6M Start Date].[Date],2)+1
    Also
    3M Start Date = EOMONTH(tbl_IncentiveLatestDate[6M Start Date].[Date],3)

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    What result do you get with this calculated column formula?

    =EDATE(tbl_IncentiveLatestDate[6M Start Date],3)

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    Create a calendar table, establish a one to many relationship between calendar table and tbl_IncentiveLatestDate based on date column. Try again with above formula.

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      This worked for me:

      3M Start Date = EOMONTH(tbl_IncentiveLatestDate[6M Start Date].[Date],2)+1
      Also
      3M Start Date = EOMONTH(tbl_IncentiveLatestDate[6M Start Date].[Date],3)