Forum Discussion
Week Filter
Hi Does anyone know why this DAX doesnt work... Prior Week = CALCULATE([UAP's],FactNELWeekly[Previous Week No.]) UAPs = count distict measure, works fine. Previous Week No. is a number col...
So, the way that I would do this in a measure would be something along the lines of:
Prior Week = VAR __PreviousWeek = MAX('FactNELWeekly'[Previous Week No.]) RETURN CALCULATE([UAP's],FILTER('FactNELWeekly'[Week] = __PreviousWeek)
HI,
It could be something like this (if it's a calculated column):
var previousWeek = FactNELWeekly[Previoud Week No.]
return
CALCULATE([UAP's],FactNELWeekly[Week No.] = previousWeek)