Forum Discussion

bgonen7's avatar
bgonen7
Icon for Helper I rankHelper I
3 years ago

Divide formula filtering through specific time periods

I have the formula below that works fine when I check the filter : "Revised cleared periods"    the formula goes like this:   Avg Receipts =  DIVIDE( SUMX('Open AR',[$Group amount]*[Arrears]),...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

bgonen7 , You need create a measure like

 

example

 

3 Months=
var _max = maxx(allselected(date),date[date]) // or today()
var _min = date(year(_max), month(_max)-3,1)
return
CALCULATE([Avg Receipts],filter(date, date[date] <=_max && date[date] >=_min))