Forum Discussion
current vs previous week count
Hi Everyone, i have seen that dax doesnt have a previous week function, can someone assist in writing a measure that shows previous week counts to compare to that current week count as shown in the...
Var _maxWeekNum = max(weeknum)
return
Calculate(
countrows(table),
filter(
all(table),
table[weeknum] = _maxWeekNum - 1
)
)
vapid128
Solution Specialist
Solution SpecialistVar _maxWeekNum = max(weeknum)
return
Calculate(
countrows(table),
filter(
all(table),
table[weeknum] = _maxWeekNum - 1
)
)