How do can I calculate months in a relative date filter to use in a measure..

[jimh153]

I want to divide values in a revenue column by the # of months selected in a relative date filter to display a run rate value

[jimh153 · Accepted solution]

That will work ! Thank you

[FreemanZ]

hi @jimh153 

try like:

AvgRunRateValue =

VAR _revenue = SUM(TableName[revenue])

VAR _months =

DATEDIFF(MIN(TableName[Date]), MAX(TableName[Date]), MONTH) + 1

RETURN

DIVIDE(_revenue, _months )