Forum Discussion
Helper IIadding 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
Super UserYou will find the answer here : https://learn.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops&tabs=private
Helper IIHi 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
What is your datasource ? I think you are using a live connection or a direct query.
- MaliniBaktha
Yes, I am using a direct query
- AmiraBedh
what is your data source ?