Forum Discussion
MaliniBaktha
Helper II
Helper IICurrent 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...
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
Super UserSubtract 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.
MaliniBakthaI 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?
- lbendlin
Neither dates are useful. Always use dates from your fact table to identify when the last activity was reported.
- MaliniBaktha
so the problem with our calendar table is I dont have a weekday column to choose the recent activity
These are the columns in my calendar date table