Forum Discussion
Week Over Week DAX Count for Previous Week
I've created a measure that uses calculated columns that counts rows with a specific value, see below. Calls This Week = CALCULATE(COUNTROWS(AllContacts),FILTER(AllContacts,AllContacts[Contact_S...
Hi ULTRAVI0LENCE ，
try like:
CountPreviousWeekColumn=
COUNTROWS(
FILTER(
AllContacts,
AllContacts[Contact_System]="Call Center"
&&AllContacts[WeekRank] = EARLIER(AllContacts[WeekRank]) -1
)
)
Thank you for the reply,
The EARLIER DAX expression does not accept my column AllContacts[WeekRank] as a parameter. An error is thrown on this specific parameter. Any tips on this?