Using SWITCH to show previous field value

Hi,

I have this list:

Sprint 1

Sprint 2

Sprint 3

Sprint 4

Sprint 5

Each of the sprints has Story Points associated (Numbers)

For each Sprint , I need the SUM of Story Points of the PREVIOUS Sprint. (For example, for Sprint 2, I need the sum of Story Points of Sprint 1)

So for that, I am using SWITCH, to bring the Sprint Name and the measure of the SUM of Story Points for the PREVIOUS Sprint:

This is an example of the measures I have created

Notice that in the SWITCH , I am calling the Sprint name with the measure of the previous Sprint,

I put the Zero just because I was testing, but, any ideas why is not working ? it is showing blank values.

Thanks in advance.

az38
6 years ago
Anonymous

hi. as you use a measure that enables row-context use a ALL() inside FILTER, like

SUMX(FILTER(ALL(RSRI),RSRI[Sprint Name]=....
az38
6 years ago
Anonymous

did you check it? I'm already not sure this works, maybe your issue is more complicated

Forum Discussion