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)
Solved:
UAPs Prior Week = VAR __PreviousWeek = MAX('FactNELWeekly'[Previous Week No.])
return
CALCULATE([UAP's],FactNELWeekly[Week] = __PreviousWeek)
Thanks to all who contributed!