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.
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
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.
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?
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.
Simple select both column and multiply using number function by single click
pl a series on Power piovot and power BI.thank yu
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.
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
Please which version of Excel are you using because I cannot find columns from examples in my own. I am using 2016
Thanks a lot.
Hey Can i use IF statement , e.g. if Sales = 0 then nothing else SALES * 2
how to add a column in front of the first column of the table
Thanks, how can we make column total at the bottom of your added column “Sale Value”
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.
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?
Thank you
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.
Try adding "Date.AddDays" in front
Thanks
yes.