number of months between a date and the current date

[Ranahazim]

hi

i am trying to calculate the number of months between a certain date and the current date,

can u help me.

i only find solutions for 2 dates but i need the second date to be dynamic 

thanks 

[ofirk · Accepted solution]

Hi,

If you have a date column, for example [dateColumn], you can use the following DAX calculation:

new column = DATEDIFF([dateColumn], NOW(), MONTH)