Average of Month

[Anonymous]

Hi All,

Guide me in getting average value.

Example

Year

2016

2017

Month

Jan to Dec (2106 Year)

Jan to Mar(2107 Year)

If user selects 2017 , the average value should be

Jan 2017 + Feb 2017 + Mar 2017 / 3

If user selects 2016 , the average value should be

Jan 2016 + Feb 2016 + Mar 2016 ......... Dec 2016 / 12

Thanks in advance

[sunny_talwar]

May be like this

Sum(Measure)/Count(DISTINCT Month)