Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Trying to figure out the syntax for a week-to-date measure based on Sunday being the first day of the week.
Does anyone have anything that could point me in the right direction?
Here is what I have done for MTD:
CALCULATE ( SELECTEDMEASURE (), CALCULATETABLE ( DATESMTD ( 'Calendar'[Date] ), 'Calendar'[IsPast] = TRUE () ) )
I think you can find the answer in the following link:
For Sunday being the first day make sure in the weekday formula to put the number 1 (as return type).
e.g. WEEKDAY('Date'[Date],1)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.