Forum Discussion
Current week dax function without a calendar table
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
Activities are in your fact table, not the calendar dimension table.
I would recommend you mark your Dates table as such (which validates contiguity) and to disable auto/date time hierarchies.
is this disable option in the format section?