Need to Get the Running Total from Current week Onwards

[Anonymous]

Hello,

I am trying to create a measure which will give me the running total from Current Week till last week(want to capture for entire year).

However the catch is that I dont want to include the revenue value from Week 1 to 4(assuming week 5 is my current week).

How can I get the right numbers-, this is what I am using right now-

Running Total=

IF(CALCULATE(MAX(' (Fiscal Calendar)'[Quarter Week Aging])>=0),
CALCULATE(
'[Revenue ],
FILTER(
ALLSELECTED('Fiscal Calendar'[Quarter Week Num], 'Fiscal Calendar'[Quarter Month Num]),
ISONORAFTER('Fiscal Calendar'[Quarter Week Num], MAX('Fiscal Calendar'[Quarter Week Num]), DESC)
)
))

above is what i am getting right now, however what i need is running total rev in week 5 should be 44M, in week 6 it should be (44M+66M=110M)..But right now in Week 5 i am getting the commulative revenue from wk 1to 5, which is not what i want.

TIA

AP

[Dangar332]

Hi, @Anonymous 

try below measure 

measure =

SUMX(
  FILTER(
     ALL(re),re[week num]<=MAX(re[week num]) && re[week num]>4),
  re[revenue]
)+0