cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Getting the difference from two columns

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

 

1 ACCEPTED SOLUTION

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

5 REPLIES 5
Super User III
Super User III

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






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.





Anonymous
Not applicable

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)

Anonymous
Not applicable

Any ideas?

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

Anonymous
Not applicable

I will try that right now and let you know

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors