Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MaliniBaktha
Helper I
Helper I

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 every monday date as my data as of function. But since I dont have a calendar table attached is there any solution ?

MaliniBaktha_0-1692874598747.png

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

7 REPLIES 7
lbendlin
Super User
Super User

lbendlin
Super User
Super User

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 

MaliniBaktha_0-1694697544381.png

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?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.