Adding calculated value across different queries

[Anonymous]

Hi Fellow BI Users,

I am facing difficulty to add two calculated parameters across different query. 

Query 1: Has the company's entire invoices.  I filter it across different fields to find the net invoice value that my unit has been billed

Query 2: Has the company's entire purchase orders that have not been not been invoiced. I filter it across different fields to find the net value of purchase orders placed by my unit that are yet to be invoiced.

I just want to display the Remaining Budget of my unit which is given by the formula

Remaining Budget= Budget Allocated (A constant)- (Sum of invoice value that is calculated in Query 1)- (Sum of purchase order value that is calculated in Query 2)

There are no common fields among these dataset through which I can draw a relationship. The invoice number and the purchase order numbers are different Please need your help.

I want to add the "GR Forecast" value that is calculated in tab "PO Analysis" with the two values "CQ GOLD Hit" and CQ NON GOLD hit- displayed in a different tab "P&L Analysis" .

GR Forecast= Sum of purchase orders values that will come in this quarter

CQ GOLD Hit+CQ Non GOLD Hit=Values of invoices that has already been billed to me and I will have to pay

So the remaining budget that I will have= A budget (that is allocated to me at start fo quarter)-GR forecast-CQ GOLD hit-CQ Non GOLD hit.

I want to display the remaining budget at any of the one tab in PowerBI

[v-yingjl]

Hi @Anonymous ,

Not certain what is your expected output based on the description. Whether consider providing some sample data without any sentive information about it.

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Community Support Team _ Yingjie Li

[Anonymous]

Hello Li,

Thanks for the link. I have now added the actual snapshots of my BI so that viewers may have clarity of what I am trying to do.