Forum Discussion
Solved
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 =...
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.
by the way, why are my datediff formulas not able to see the date fields?