Forum Discussion
DAX formula for Calendar month difference between two dates ?
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...
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.
2 Replies
by the way, why are my datediff formulas not able to see the date fields?
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.
