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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Getting the difference from two columns

‎12-13-2018 10:04 AM

Hello i have the following graph:

FLOW-credit.PNG 

The black bars represent the money flow (What comes in and what goes out) on certain diferrent business and the green bars are the credit that are linked to that business so to get the actual balance i need to get a difference between the black bar and the green bar. However the actual money flow comes from one table and the credit comes from another table. I have relationships set for the business name so i can display it like it is right now

 

Labels:
Message 1 of 6
702 Views
0
1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee
In response to Anonymous

‎12-13-2018 10:42 PM

Hi @Anonymous,

 

It seems they are columns. How about the formula below?

 

Measure =
SUM ( 'table1'[Credito] ) - SUM ( 'table2'[Saldo(ingresos-egresos)] )

 

Best Regards,
Dale

Community Support Team _ Dale
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

Message 5 of 6
670 Views
5 REPLIES 5
parry2k
Super User
Super User

‎12-13-2018 10:19 AM

@Anonymous can yu share the data model on how these tables are related? What is used on x-axis? 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 6
695 Views
0
Anonymous
Not applicable
In response to parry2k

‎12-13-2018 10:46 AM

rel.PNGThey are related by the name of the business and the axis is the name of the business (On the relationship it shows as obra)

Message 3 of 6
688 Views
0
Anonymous
Not applicable
In response to Anonymous

‎12-13-2018 09:00 PM

Any ideas?

Message 4 of 6
678 Views
0
v-jiascu-msft
Employee
Employee
In response to Anonymous

‎12-13-2018 10:42 PM

Hi @Anonymous,

 

It seems they are columns. How about the formula below?

 

Measure =
SUM ( 'table1'[Credito] ) - SUM ( 'table2'[Saldo(ingresos-egresos)] )

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 5 of 6
671 Views
Anonymous
Not applicable
In response to v-jiascu-msft

‎12-19-2018 09:20 AM
I will try that right now and let you know
Message 6 of 6
662 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All