Divide a measure by the number of days that are filtered

[Anonymous]

Hi there, 

I have a measure which I would like to divide the sum of by the number of days that have been selected on the filter. 

As an example, I have the selected the last 18 calender months on my filter whilst filtering total revenue and I am looking to filter the revenue by the 547.50

Any help would be appreciated.  

[amitchandak]

@Anonymous , a measure like

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
Divide( sum(Table[Value]),datediff( _min ,_max,day)+1)

[Anonymous]

Hey Amita, I used Divide(Measure, COUNTROWS(Calender)) 

And it seems to have worked. 

Can you see any issues with using this?

Best, 

[Anonymous]

Hi @Anonymous ,

That should work if it is a standard calendar.

You could also consider if there are duplicate values or missing dates in the calendar table depending on your needs.

Best Regards,

Jay