Number of Months between a date and current month

[ctedesco3307]

Want to create a rolling ytd column  to show the number of months between a start date and today.

Need to include the year also - so for example the first row would return 12 not 0 b/c start date is in 2021 

Thanks in advace! 

[AlexisOlson]

Another simple method:

Date.Year([EndDate]) * 12 + Date.Month([EndDate]) - Date.Year([StartDate]) * 12 - Date.Month([StartDate])

[ctedesco3307 · Accepted solution]

not perfect but works 

https://community.powerbi.com/t5/Desktop/Calculate-number-of-months-between-two-dates-in-PowerQuery/...