Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hello,
I want to aggregate series, I am attaching a picture of my idea, does anyone have an existing solution?
Thanks for your help!! 🙂
Solved! Go to Solution.
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]))
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.
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]))
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 😄
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/
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
28 | |
28 | |
12 | |
12 | |
12 |