calculate months between two dates without taking in account the day

[AFra]

Hi all, 

I would like to calculate the number of months in a list. For each element, I have a start date and an end date. I would like to count the number of months between the two dates, regardless of the day and including the starting and ending months. For example:

• start date 31-01-2020
• end date 10-02-2020
• result: 2 months

any idea how to do that? 

[Ritaf1983 · Accepted solution]

Hi @AFra 
Datedif function
When calculating intervals between months, Dax does not account for whether exactly 30/31 days pass between months.
Thus, its standard form will give you the difference you asked for.

MonthQTY = DATEDIFF('Table'[Start ],'Table'[End],MONTH)

As you added an extra month in your example, just add 1 at the end.

ExtraMonth = DATEDIFF('Table'[Start ],'Table'[End],MONTH)+1

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.