DAX formula for Calendar month difference between two dates ?

[Zarlot531]

So I know there are complicated ways to do this, but I was wondering what the simplest way would be to the following types of differences between dates:

Some examples: 

1/31/2019 - 2/1/2019 = 1 

1/25/2019 - 1/26/2019 = 0

3/1/2019 - 4/30/2019 = 1 

3/1/2019 - 5/1/2019 = 2 

In other words, it's built off the month rather than the days. Datediff doesn't seem to be consistent here... 

[v-yuta-msft · Accepted solution]

@Zarlot531 ,

You can simply create a calculate column using dax as below:

Monthdiff = DATEDIFF(Query1[SoldMonth], Query1[EndMonth], MONTH)

  

You can also refer to the pbix file.

Community Support Team _ Jimmy Tao

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

[Zarlot531]

by the way, why are my datediff formulas not able to see the date fields?