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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Go to the Power Query Editor or the Data View in Power BI, and create a new calculated column in your calendar table. You can name it something like Last Monday of Year

 

try this formula to calculate

Last Monday of Year = VAR CurrentYear = YEAR(Calendar[Date]) VAR LastDayOfYear = DATE(CurrentYear, 12, 31) VAR DaysToSubtract = WEEKDAY(LastDayOfYear, 2) - 1 RETURN LastDayOfYear - DaysToSubtract