Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DATEDIF months calculation

Hey guys, I'm having troubles with the DATEDIF function. I'm trying to calculate the month difference between a project end date and the date of today.   I'm using:   Month Delay = DATEDIFF(Proj...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    Please use the following formula and check if it works fine.

    MonthDelay=ROUND(DIVIDE(DATEDIFF(DATE(2018,5,31),TODAY(),DAY),30),0)


    Best Regards,
    Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous

 

When you mention the interval as Month, Power BI extract the month number and calculate the difference. So, in your example it will be 8-5= 3 and it actually wont calculate the no of days.

 

Thanks

Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    The only way to solve this is to calculate the day's dif and divide it to 30? 

     

    I think this is not a good way to calculate it since there are months with 31 days and others with 29...