Counting Months between two dates

[cmcreynolds]

I have a start date and graduation date for each student - is there a particular DAX function to count the number of months between these two dates?

Or should I utilize Month #s and Years to get the count? Or the number of days?

 

[cmcreynolds]

Okay, so this formula works - I don't have graduation data for everyone, that's why I added the IF() with Blanks

=IF([Graduation Date]<>BLANK(),(YEAR([Graduation Date])-YEAR([StartDate]))*12+MONTH([Graduation Date])-MONTH([StartDate]),BLANK())

 

[Data_Analyst_inTraining]

I used YEARFRAC(). To get the months between two dates:

= YEARFRAC(DATE(2020,9,1),TODAY(),1)*12)

...to get whole numbers wrap in INT() or ROUNDUP() depending on on if you want to count partial months or not

 

[SunnySchindler]

I used YEARFRAC(). To get the months between two dates:

= YEARFRAC(DATE(2020,9,1),TODAY(),1)*12)

...to get whole numbers wrap in INT() or ROUNDUP() depending on on if you want to count partial months or not

Above formula outputs non zero for same month. Is this formula dependent on number of days? Is there formula that treats input in month not days; i.e. zero if dates are same month. Thanks Ahead!