Forum Discussion

Miranda1361's avatar
Miranda1361
Regular Visitor
3 years ago

Calculate Average Monthly Run Rate

Need to calculate the average run rate for each month in the year on the 8th day of the month. Example: I have the total for the year; $4,857,536.00 and need to figure out how much of it belongs to e...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Miranda1361 , With help from date table Avg till last month end

 

YTD =
var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),-1)
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE(Averagex(Values('Date'[Month Year]) , [Your Measure])  ,DATESBETWEEN('Date'[Date],_min,_max))

  • Miranda1361's avatar
    Miranda1361
    Regular Visitor
    3 years ago

    Thank you for the solution. I don't believe it calculates 8 days since the end-of-month date, as requested. Is this correct?