Forum Discussion

ac10304's avatar
ac10304
Frequent Visitor
7 years ago
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],...
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • ac10304's avatar
    ac10304
    Frequent Visitor
    7 years ago

    THanks for your reply Anonymous, this helps clear up my confusion.


    A follow up question: is there a way to get the results like in excel?
    Or is it good practice to have it round up as it shows in power bi

     

    thanks again