Need to Get the Running Total from Current week Onwards

Anonymous — Wed, 20 Dec 2023 10:17:18 GMT

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

Re: Need to Get the Running Total from Current week Onwards

Dangar332 — Wed, 20 Dec 2023 11:10:12 GMT

Hi, Anonymous

try below measure

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

topic Need to Get the Running Total from Current week Onwards in DAX Commands and Tips

Need to Get the Running Total from Current week Onwards

Re: Need to Get the Running Total from Current week Onwards