Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Adding calculated value across different queries

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

 

 

 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.