Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Premlatapandey9
Microsoft Employee
Microsoft Employee

How to store data in the table based on time

Hello Everyone,

 

I have a table with issues and percentage for current month and average but i do not have any table yet where i can show this avergae is for particular month and for every changing month it should add the month and average of issues automaticaly to that table, can you please help me to get that ?

for example october month avergae is 22.47 and and suppose november it would be 25 then in the table this should automaticaly show that for october it was 22.47 and for nov it is 25 

Table 1    
Issues NamePercent   
Sales82.86   
Prod21.27   
Eng6.06   
Quality1.09   
Admin1.05 Average Issues for october 22.47
     

 

Thanks and Regards

@members 

2 REPLIES 2
Premlatapandey9
Microsoft Employee
Microsoft Employee

Hello @Anonymous 

 

I think I wasnt able to explain better please have a look below and help me

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

Anonymous
Not applicable

Hi @Premlatapandey9 ,

 

I think you can use dynamic title in card visual to show the monthname in card title.

Measure:

Title = 
VAR _Current_MonthName = FORMAT(TODAY(),"MMMM")
RETURN
_Current_MonthName

RicoZhou_0-1664520121497.png

Due to today is 2022/09/30, so the data should in September. When the date be 2022/10/01 (tomorrow) and your data refresh, your total will show October.

RicoZhou_1-1664520218958.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.