Forum Discussion
12 months average
Hi all, I have req as doing average for each month Before I was showing count (I'd) for each date, mknth, year Now I want to show average like In Jan if I have count of id 700 then avg will b...
Anonymous You need to provide the sample data here for the assistance.
From your question, the general guideline is to create a virtual table in a measure for the purpose to scan for the month (as the denominator), and as well calculate the count of your records (nominator) in the same measure.
Finally, returning the answer as nominator/denominator.
I provided, please check