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: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
aishak12
Helper IV
Helper IV

Multiply Two Calculated Columns in Power Query Editor

‎03-20-2021 03:51 PM

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  

 

aishak12_1-1616280459666.png

 

 

Then in Power Query Editor I created these conditional columns 

 

aishak12_2-1616280496403.pngaishak12_3-1616280551506.png

 

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

 

Labels:
Message 1 of 2
1,323 Views
0
1 REPLY 1
PhilipTreacy
Super User
Super User

‎03-20-2021 06:31 PM

Hi @aishak12 

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

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Message 2 of 2
1,274 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All