Forum Discussion

Premlatapandey9's avatar
Premlatapandey9
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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 changin...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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.

 

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.