Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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 5/01/2018 and 12/01/2018.
and i want this sum begin from 5/01/2018 by 0 and not the cumulative number since 01/01/2017
i'd like to put a 0 ât the beginning instead of a 18
Someone can help me
What is the formula for your measure?
**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...
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 60 | |
| 52 | |
| 42 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 123 | |
| 104 | |
| 44 | |
| 32 | |
| 24 |