How to store data in a table based on month calculation

[Premlatapandey9]

Hello Everyone,

I am posting this request again as i was not able to get the help please find the question and details below

So I have Table 1 created out of data scores like below 

Table 1
Issues	Name&Percent
Sales	82.86
Prod	21.27
Eng	6.06
Quality	1.09
Admin	1.05
		Avg of issues for Sep	22.47
In next month  Table 1 one will have different value
Issues	Name&Percent
Sales	85.86
Prod	25.27
Eng	7.06
Quality	1.09
Admin	1.05	Avg of issues for Oct	24.06
So I want to create another table which can store month wise average data based on Table 1
Average Table
Avg of issues for Sep	22.47
Avg of issues for Oct	24.06

Thanks and Regards

Premlata

@memmbers 

[tamerj1]

Hi @Premlatapandey9 

how do you filter the tables to the desired month? Are you using two separate measures? Do you have a date table? Do you have a month column?

[Premlatapandey9]

Hello @tamerj1 I have data in various tables out of that i have created some measures and from that i am getting these values, I have a product created date in database but i am not able to show this calcuated average against product created date, based on product created date it is spreading the average over years and what i want what is total average of this month and when next month comes then also i should see what was total average for last month and what is for this month...

this is the visual i have and i want this to keep this value next month also with the next month value in seprate dot.

Thanks and Regards

Premlata