Sales-WTD = VAR CD = LASTDATE( 'Calendar'[Date] ) VAR CY = MAX( 'Calendar'[Year] ) VAR WeekDayNo = WEEKDAY( LASTDATE( 'Calendar'[Date] ), 3 ) RETURN CALCULATE( [Total Sales], DATESBETWEEN( 'Calendar'[Date], DATEADD( CD, -1 * WeekDayNo, DAY ), CD), 'Calendar'[Year] = CY )
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter