Forum Discussion
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 ...
Hi Datediff in always ROUNDUP, for Always rounddown you may use -1 like this:
diference = DATEDIFF(Table1[Column1];Table1[Column2];MONTH)-1
Hi Datediff in always ROUNDUP, for Always rounddown you may use -1 like this:
diference = DATEDIFF(Table1[Column1];Table1[Column2];MONTH)-1
Thank you 🤗🤗