Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Anonymous
Not applicable

TRICKY - Diagonal Sum Power Bi Table

‎07-02-2021 07:31 AM

Hi Experts

 

See attached sample pbix file and and excel table with end result. How would do the following sum in Power BI.

Excel End Result

Capture.PNG

 

 

 

 

 

 

 

 

 

 

Sample Data PBIX

Link: https://www.dropbox.com/s/cbkdjswtlshrp4d/sample.pbix?dl=0 

Labels:
Message 1 of 5
576 Views
0
1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

‎07-02-2021 08:39 AM

@Anonymous

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

sample(3).pbix
Message 2 of 5
522 Views
0
4 REPLIES 4
ryan_mayu
Super User
Super User

‎07-02-2021 08:39 AM

@Anonymous

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




sample(3).pbix
Message 2 of 5
523 Views
0
Anonymous
Not applicable
In response to ryan_mayu

‎07-02-2021 08:42 AM

Thank you sir.....excellent feedback.

Message 3 of 5
520 Views
0
ryan_mayu
Super User
Super User
In response to Anonymous

‎07-02-2021 08:42 AM

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Message 4 of 5
518 Views
0
Anonymous
Not applicable
In response to ryan_mayu

‎07-02-2021 10:10 AM

Not sure if you would be interested in - Similar to the above question

https://community.powerbi.com/t5/Desktop/TRICKY-Diagonal-Sum-to-Sum-a-Range-of-Data/m-p/1935736#M737...

 

Message 5 of 5
498 Views
0

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.

View All