Forum Discussion

Mo-PHAT's avatar
Mo-PHAT
Icon for Helper I rankHelper I
9 years ago
Solved

DATEADD not accepting negative numbers

Hi,   I am trying to create a column which displays the date 3 months before today.   My DAX query is simple - 3 months ago = DATEADD('Datasource'[Today].[Date],-3,MONTH) I created a column with...
Need Help
  • Mo-PHAT's avatar
    Mo-PHAT
    9 years ago

    OKAY one of my super smart colleagues found that if we are trying to pass over the start of the year it will not work.

     

    Today being the 31 Jan 2017, any DATEADD with a negative number that tries to go before the start of the year just returns a blank column.

     

    Surely this is a major flaw!?

     

    I'll  relog this as an issue.