30 - Adding a Custom Column in Power Query in Excel

In this video, I will show you how to add a custom column in your data in Power Query editor

#Excel #PowerQuery #ExcelTips

[chandramohan]

pl a series on Power piovot and power BI.thank yu

[silverfunnel]

Hello Sir, would it be possible to select a column and position the custom column after that column and not at the end? Or is it common sense to drag it to the right position after having created it?

[JamesBond-qggx]

Thanks, how can we make column total at the bottom of your added column “Sale Value”

[prasad]

Simple select both column and multiply using number function by single click

[originalkundukulangara]

Please which version of Excel are you using because I cannot find columns from examples in my own. I am using 2016

[silverfunnel]

Hello, is it possible to insert a custom column between two columns or is it common sense to write the formula and move the created column to the right position.

[jay]

Hey Can i use IF statement, e.g. if Sales = 0 then nothing else SALES * 2

[charizad_bg]

hi sir, i have two coloumns as created date and time, i need to add an additional col. where i need to write custom formula if time is above 5pm then created date+1 else created.

[madhun]

How to insert additional columns or rows to existing power query… I want to add weekday percentage of targets they reached in my teams score card. Please help how to do

[syafourardian]

how to add a column in front of the first column of the table

[RohitThakur-kusb]

Hi, need ur help. I want the dates which is greater than 7 days. Like in column a I have 01/01/2020 the I need the formula to add 7 days and get 08/01/2020 in next column.