Forum Discussion
adding every monday as a calendar date
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
You should still be able to add a new query even if you're using direct query. Try this in a blank query
= DateTime.SwitchZone(DateTimeZone.LocalNow(), yourzone as number)
//you can wrap the step above in DateTime.From if you don't need the timemzone or DateTime.From if you need just the dateLoad it to the model and use it in a card as max or min (doesn't matter either way)
If refreshed is done via service, the timezone is UTC so you need to convert it to your own timezone.
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
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.