Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to calculate “Cumulative”

Hi everyone,  I've a calculated column named "WeekNum" that returns the number of week of a date and a measure named "Total Sellouts" that calculates total sellouts for each week.  The formula of t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi there, I solved my problem.

     

    Cumulativo =
    SUMX (FILTER (ALLSELECTED ( 'MyTable'[WeeksNumber] ), 'MyTable'[WeeksNumber] <= MAX('MyTable'[WeeksNumber])), [SellOuts])
     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous
I can't use CALCULATE(SUM('MyTable'[Total Sellouts]) because Total Sellouts is already a measure. 

Total SellOuts =  

var x = CALCULATE(SUM('MyTable'[Qt_1]),FILTER('MyTable', 'MyTable'[Date].[Year] = YEAR(TODAY()))) 

var x = CALCULATE(SUM('MyTable'[Qt_2]),FILTER('MyTable', 'MyTable'[Date].[Year] = YEAR(TODAY()))) 

return x - y 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Anonymous ,

 

Can you able to provide sample data with date column.