Forum Discussion
Solved
DateDiff adding an extra day?
I have a simple DateDiff function to calculate the # of months between a "date received" column and whatever the current date is. My function is: Num Months Open = DATEDIFF(Table1[Date Received],...
Hi ac10304
DATEDIFF in Power BI doesnt work that way. When you specify the interval as Month, it takes the Month of Date1 & Date 2 and finds the difference. So in your case, 9-2= 7. Even if you find the differene between 2/28/1028 and today in terms of month, it will be 7.
Hope this clears your doubt.
Thanks
Raj
