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: 
Reply
Anonymous
Not applicable

Add new column by multiplying column with specific row value

‎11-22-2021 08:38 PM

I need to do a multiplication from column PRICE and multiply with value from second row from column RATE as table below:

 

Aziz_Arrashid_0-1637642259250.png

Really appreciate any help on how to do it in power query.

Labels:
Message 1 of 2
163 Views
0
1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

‎11-22-2021 09:50 PM

NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})

View solution in original post

Message 2 of 2
89 Views
1 REPLY 1
wdx223_Daniel
Super User
Super User

‎11-22-2021 09:50 PM

NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})

Message 2 of 2
90 Views

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

View All