Forum Discussion
Number of Months between two dates
This seems like a really dumb thing to be asking. I need to count the number of Months between two dates. I can happily find out the number of days, but that doesn't help much as number of days ...
It is the same function in DAX as Excel. Create a measure like:
Months = DATEDIFF([start],[end],MONTH)
https://msdn.microsoft.com/en-us/library/dn802538.aspx
EDIT: Hang on, just caught the reference to PowerQuery, give me a minute.