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)
Greg_Deckler
Community Champion
Community ChampionSo, 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)Thank you so much, this worked!
Much appreciated.