Forum Discussion
MaliniBaktha
Helper II
3 years agoCurrent week dax function without a calendar table
Hi, I am trying to put my refresh date as to show the data refreshed date as of now in my dashboard. But I dont have the calendar table. If I have a calendar table then I know the dax to put the ev...
- 3 years ago
Subtract the weekday of the date from the date (select the option where monday is 0 and sunday is 6). That will always return the monday of that week.
lbendlin
Super User
3 years agoSubtract the weekday of the date from the date (select the option where monday is 0 and sunday is 6). That will always return the monday of that week.
MaliniBaktha
Helper II
3 years agoI used a today function thinking that will show the date of my refresh. But it is typically wotking as current date. How do I use your suggestion in DAX?