Monthly Archives: December 2013

An Unique Excel Filter Aid

Advertisements

DAX measure for WTD calculation

The following DAX measure will return the week-to-date total from a PowerPivot table containing only a Date and SUM column. No calendar table or other calculated fields are needed with this measure.

WTD:=CALCULATE(SUM([Sum]),DATESINPERIOD(Table1[Date],LastDate(Table1[Date]),-WEEKDAY(LastDate(Table1[Date])),DAY))