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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
o0mixkea
New Member

combine the last 4 columns with sumx?

‎08-04-2022 06:56 AM
I would like to combine the last 4 columnswould sumx work? using & allen & allen_pine & allen_rex - works
unknown (1).png
unknown (2).png
Labels:
Message 1 of 3
279 Views
0
1 ACCEPTED SOLUTION
ray_ux
Memorable Member
Memorable Member

‎08-04-2022 06:59 AM

@o0mixkea Using & is turning your result into a string
Try

Sum('Allen_p2'[Allen_ANR]) + Sum('Allen_p2'[Allen_Rex]) .... Etc

 

 

View solution in original post

Message 2 of 3
274 Views
2 REPLIES 2
ray_ux
Memorable Member
Memorable Member

‎08-04-2022 06:59 AM

@o0mixkea Using & is turning your result into a string
Try

Sum('Allen_p2'[Allen_ANR]) + Sum('Allen_p2'[Allen_Rex]) .... Etc

 

 

Message 2 of 3
275 Views
o0mixkea
New Member
In response to ray_ux

‎08-04-2022 07:00 AM

sumx() + sumx() works great thank you!

Message 3 of 3
273 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All