Forum Discussion
Solved
Current 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.
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.
I 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?
Neither dates are useful. Always use dates from your fact table to identify when the last activity was reported.
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
