How to store data in the table based on time

Question

Hello Everyone,&nbsp;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&nbsp;Table 1&nbsp;&nbsp;&nbsp;&nbsp;Issues NamePercent&nbsp;&nbsp;&nbsp;Sales82.86&nbsp;&nbsp;&nbsp;Prod21.27&nbsp;&nbsp;&nbsp;Eng6.06&nbsp;&nbsp;&nbsp;Quality1.09&nbsp;&nbsp;&nbsp;Admin1.05&nbsp;Average Issues for october&nbsp;22.47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks and Regards@members&nbsp;

anonymous · Answer

Hi&nbsp;Premlatapandey9&nbsp;,
&nbsp;
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

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.

&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;

premlatapandey9 · Answer

Hello&nbsp;Anonymous&nbsp;&nbsp;I think I wasnt able to explain better please have a look below and help meSo I have Table 1 created out of data scores like below&nbsp;Table 1&nbsp;&nbsp;&nbsp;IssuesName&amp;Percent&nbsp;&nbsp;Sales82.86&nbsp;&nbsp;Prod21.27&nbsp;&nbsp;Eng6.06&nbsp;&nbsp;Quality1.09&nbsp;&nbsp;Admin1.05&nbsp;&nbsp;&nbsp;&nbsp;Avg of issues for Sep22.47&nbsp;&nbsp;&nbsp;&nbsp;In next month&nbsp; Table 1 one will have different value&nbsp;&nbsp;&nbsp;&nbsp;IssuesName&amp;Percent&nbsp;&nbsp;Sales85.86&nbsp;&nbsp;Prod25.27&nbsp;&nbsp;Eng7.06&nbsp;&nbsp;Quality1.09&nbsp;&nbsp;Admin1.05Avg of issues for Oct24.06&nbsp;&nbsp;&nbsp;&nbsp;So I want to create another table which can store month wise average data based on Table 1&nbsp;&nbsp;&nbsp;Average Table&nbsp;&nbsp;&nbsp;&nbsp;Avg of issues for Sep22.47&nbsp;&nbsp;Avg of issues for Oct24.06&nbsp;&nbsp;&nbsp;Thanks and RegardsPremlata

Forum Discussion

How to store data in the table based on time

2 Replies

Related content

Stored Procedure to Manipulate Tables

regarding storing multiple tables in lake house

Store Activity Data into a Table

Customer group split based on stores

FILTER TABLE BASED ON ANOTHER TABLE

Table 1
Issues Name	Percent
Sales	82.86
Prod	21.27
Eng	6.06
Quality	1.09
Admin	1.05	Average Issues for october	22.47

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