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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
borniex
Frequent Visitor

aggregate series

Hello,
I want to aggregate series, I am attaching a picture of my idea, does anyone have an existing solution?
Thanks for your help!! 🙂

5b7793.jpg

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @borniex 

 

You can try the following methods.

Column:

previous part = CALCULATE(MAX('Table'[part]),FILTER('Table',[id]=EARLIER('Table'[id])-1))
judgement = IF([part]=[previous part],1,0)//Determine if the part is the same as the previous id
First part = IF([judgement]=0,1,0)
Max ID = CALCULATE(Max('Table'[id]),FILTER('Table',[id]<=EARLIER('Table'[id])&&[First part]=1))
Sum value = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[Max ID]))

vzhangti_0-1689746790266.png

vzhangti_2-1689746829298.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

3 REPLIES 3
v-zhangti
Community Support
Community Support

Hi, @borniex 

 

You can try the following methods.

Column:

previous part = CALCULATE(MAX('Table'[part]),FILTER('Table',[id]=EARLIER('Table'[id])-1))
judgement = IF([part]=[previous part],1,0)//Determine if the part is the same as the previous id
First part = IF([judgement]=0,1,0)
Max ID = CALCULATE(Max('Table'[id]),FILTER('Table',[id]<=EARLIER('Table'[id])&&[First part]=1))
Sum value = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[Max ID]))

vzhangti_0-1689746790266.png

vzhangti_2-1689746829298.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Thank you very much, I was interested in this solution! Elegant, I thought more complicated 😄

gregoliveira
Helper II
Helper II

Hi.


You will need to read about the windows function (https://www.sqlbi.com/articles/introducing-window-functions-in-dax). I have never used it, but I understand that it can deal with you scenario.

Greg Oliveira
https://www.linkedin.com/in/gregomelo/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.