Forum Discussion
Solved
Cumulative sum Problem
My Cumulative Sum measure is not calculating correctly. I have a "Is In Range" column that show 1 for weekday starting today and 0 for weekend. I want to make a table out of it with first column a...
learner03 , Are you looking for WTD. Not very clear with you example
WTD = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank]) && 'Date'[WeekDay]<=max('Date'[WeekDay])))
LWTD = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1 && 'Date'[WeekDay]<=max('Date'[WeekDay]) ))
where week rank is column
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.