Multiply Two Calculated Columns in Power Query Editor

[aishak12]

Hi All, 

I have an SQL View that is structured as entries for example. Shown below is Period (202001) having two entries. 
           1)  Salaries - Direct Labor 

           2) Net Revenue Multiplier  

Then in Power Query Editor I created these conditional columns 

So Now I would like to multiply these two columns for a new column [Net Revenue]. However since these entries are in different rows PowerBI is not returning any value. Is there anyway to work around this?

Thank you

[PhilipTreacy]

Hi @aishak12 

Please show what the data looks like in PQ.  Suply some sample data if you can.

regards

Phil