Forum Discussion

MaliniBaktha's avatar
MaliniBaktha
Icon for Helper II rankHelper II
2 years ago
Solved

adding every monday as a calendar date

hi,    I want to refresh my data every monday, but my data is looking at yearly values. Now I want to create a date slicer inside my dashboard to let the viewers know the data is refreshed every mo...
Need Help
Show and Tell
Tips and Tricks
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    The title of the question is different from what you described in the body. 

    If you are refreshing data every monday, you may need to have that info coming from your datasource.

    In other words, you are trying to display the date of the monday for the current week : 

     

    The data is refreshed on Monday = 
TODAY() - WEEKDAY(TODAY(), 2) + 1

     

     

     

MaliniBaktha's avatar
MaliniBaktha
Icon for Helper II rankHelper II
2 years ago

danextian is this to get a current date in the visuals because I have already used the current date function but I want the date of the refresh as the date 

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

I assumed you wanted the refresh date or was it something else? The M code I gave will give you the date of refresh as it updates only upon refresh and not based on today's date. Of course, if today was a Monday and you refreshed today then today would be the same as the refresh date.