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
What is your datasource ? Is it an Excel file, a SQL database?
You need to schedule the refresh https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Hi Amira, I know how to schedule the refresh on my power BI report. I have scheduled the refresh every monday but I want that date to reflect on visuals so the viewers can look at the date of the refresh when viewing the visuals
You will find the answer here : https://learn.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops&tabs=private
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 ...
What is your datasource ? I think you are using a live connection or a direct query.