Forum Discussion

MaliniBaktha's avatar
MaliniBaktha
Icon for Helper II rankHelper II
3 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    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.

MaliniBaktha's avatar
MaliniBaktha
Icon for Helper II rankHelper II
3 years ago

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 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

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.

  • MaliniBaktha's avatar
    MaliniBaktha
    Icon for Helper II rankHelper II
    3 years ago

    is this disable option in the format section?