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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ANG1994
Frequent Visitor

Sum columns and add the result value to the next row

ANG1994_0-1685521217433.png

Hello! I can't get my head around this, thereis any way to add two columns on the same row and the anwer to be in the next row to be add again? I did the example in excel of what I need to end up with. I hope it makes sense. 🙂

Thank you in advance

3 REPLIES 3
ANG1994
Frequent Visitor

I did it with my head, but basically will be Order - Need and the anwer will be Need on the next row 🙂

Thank you for your answers

Deepak_
Helper I
Helper I

Hi @ANG1994,

Can you please show us the calculation you used in excel to get your desiered table? 
It would be more helpful.

Ahmedx
Super User
Super User

post your file, and write normally what you need. I'm sure you'll say... this doesn't work for me, it also depends on the category, index, etc.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.

Top Solution Authors
Top Kudoed Authors