Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MilanAXVII
Helper I
Helper I

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 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

 sum.PNG

i'd like to put a 0  ât the beginning instead of a 18

 

Someone can help me

 

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

What is the formula for your measure?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

**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...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.