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

Hi Amira, 

looks like I dont have the access to the advanced editor, is there any dax formula i could do show every tuesday date. like we weekday function where it turns the number of the weekday , I want to return the date of the week ... 

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

What is your datasource ? I think you are using a live connection or a direct query.

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

    Yes, I am using a direct query 

    • AmiraBedh's avatar
      AmiraBedh
      Icon for Super User rankSuper User
      2 years ago

      what is your data source ?