Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to calculate the difference between the MAX value reached in current week and the MAX value reached in previous weeks (current week not included). I am using a WEEKRANK measure to identify weeks and i created the following code. However I do not know how to exclude the current week from the "allweeks" variable.
%CHANGE_MS =
VAR thisweek = CALCULATE(MAX(GPS[Max. Speed]),FILTER(ALLEXCEPT(GPS,GPS[Player Nickname]), GPS[WEEKRANK]=MAX(GPS[WEEKRANK])))
VAR maxweek = MAX(GPS[WEEKRANK])
VAR allweeks = CALCULATE(MAX(GPS[Max. Speed]), ALLEXCEPT(GPS, GPS[Player Nickname]))
RETURN
DIVIDE(thisweek-allweeks,allweeks)
Thanks in advance!
SQ
if your WEEKRANK starts from 1 then exclude 1 from the list?
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |