Forum Discussion

Premlatapandey9's avatar
Premlatapandey9
Icon for Microsoft Employee rankMicrosoft 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...
DAX Commands and Tips
DAX Data Table
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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
    Icon for Microsoft Employee rankMicrosoft 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