Forum Discussion

MilanAXVII's avatar
MilanAXVII
Helper I
8 years ago

Cumulative Sum

hi  i need help. i have data of 2017 and beginning of 2018 i want to do a cumulative sum and put this in a graph.  until here all is right. but I want also filter my data, for example between the...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

What is the formula for your measure?

MilanAXVII's avatar
MilanAXVII
Helper I
8 years ago
**bleep** KNST = IF(CALCULATE([PeriodSelected]; ALLSELECTED(Table_owssvr)) = "Year"; [**bleep** KNST Year]; IF(CALCULATE([PeriodSelected]; ALLSELECTED(Table_owssvr))="month";[**bleep** KNST month];[**bleep** KNST day]))
**bleep** KNST day = CALCULATE([count KNqual ST]; FILTER(ALL(Table_owssvr);Table_owssvr[date] <= MAX(Table_owssvr[date])))


**bleep** KNST month = CALCULATE([count KNqual ST]; FILTER(ALL(Table_owssvr);Table_owssvr[month] = MAX(Table_owssvr[month])))

**bleep** KNST Year = CALCULATE([count KNqual ST];FILTER(ALL(Table_owssvr);Table_owssvr[date] <= MAX(Table_owssvr[date]) && Table_owssvr[year] = MAX(Table_owssvr[year])))
PeriodSelected = IF([NumberOfMonths] = 1; "Month"; "Year")

That's all.

but i'm new so i take formula here and formula there. it's a weak construction...