Forum Discussion

Premlatapandey9's avatar
Premlatapandey9
Microsoft Employee
3 years ago

How to store data in a table based on month calculation

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   
IssuesName&Percent  
Sales82.86  
Prod21.27  
Eng6.06  
Quality1.09  
Admin1.05  
  Avg of issues for Sep22.47
    
In next month  Table 1 one will have different value    
IssuesName&Percent  
Sales85.86  
Prod25.27  
Eng7.06  
Quality1.09  
Admin1.05Avg of issues for Oct24.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 Sep22.47  
Avg of issues for Oct24.06  

 

Thanks and Regards

Premlata

 

@memmbers 

DAX Commands and Tips
DAX Data Table

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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's avatar
      Premlatapandey9
      Microsoft Employee
      3 years ago

      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