roling

Hi rajannaap,

I made one sample for your reference based on your sample data as you shared.  If I misunderstand, kindly share more about that. Here I created a measure to get the avg.

Measure = var mindate = TODAY()-730
var maxdate = TODAY()-365 
var minper = YEAR(mindate)*100+MONTH(mindate)
var maxper = YEAR(maxdate)*100+MONTH(maxdate)
var net = CALCULATE(SUM(Table1[net]),FILTER(Table1,Table1[Period]>=minper&& Table1[Period]<=maxper))
var countr = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Period]>=minper&& Table1[Period]<=maxper))
return
net/countr

Then you can filter the slicer to get the avg you need.

For more details, please check the pbix as attached.

Regards,

Frank

Hi rajannaap,

We can add a what if parameter to work on it. Then create another new measure.

result = [Measure]*Parameter[Parameter Value]

Regards,

Frank