formula from dax to m

[Giada90]

Hi,

I need to create a formula like this from dax to m

dafx formula:

column1=  DATEDIFF(foglio1[field1], TODAY(), MONTH)

thanks

[DOLEARY85]

Just to follow up you can replace the today column in the datediff calc with:   Date.From( DateTime.LocalNow()) 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Giada90]

thanks!

[DOLEARY85 · Accepted solution]

Hi,

this is how the calculated column would work for datediff in months between 2 fields:

Number.Round(Number.From(([Column2] -[Column1])/( 365.25 / 12 )) ,0 )

I would create a custom column for todays date and use that as one of the fields before this column.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍