Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Month DateDiff round down to nearest month

Hi Everyone, When I'm using the DateDiff Function to get the difference between two dates it works fine, however it rounds up my dates and I would like to round this down. E.g if the difference in ...
Need Help
  • rafaelmpsantos's avatar
    rafaelmpsantos
    7 years ago

    Hi Datediff in always ROUNDUP, for Always rounddown you may use -1 like this:


    diference = DATEDIFF(Table1[Column1];Table1[Column2];MONTH)-1

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

How did you create the formula? It seems right to your needs. Please refer to the snapshot below.

Month-Date-Diff-round-down-to-nearest-month

 

Best Regards,
Dale