Average of CountRows and Graphic with Static Average

[mglomb]

Hi guys,

It seems a silly question, but I was not able to find the answer and I've been researching for ours. I need to do 2 things:

1 - Count the # of rows and get the average of # if divided by months.

Ex.

January	1000
February	1200
March	400
April	1500
May	800
June	780
Total	5680
Average	947

I can't find the formula to calculate that.

2- I need to make this average static so I can use as baseline to compare what is the fluctuation Month over Month to display it in a graphic form.

How do I do that?

[Jihwan_Kim · Accepted solution]

https://www.dropbox.com/s/sjnxshvrwoi809w/mglomb.pbix?dl=0