Hi everyone,
I'm trying to add a custom column in my query. The excel formula looks like this
But I know for a power query the syntax is different.Please Login or Register to view this content.
Can someone help me please.
Thank you,
-Justin
Hi everyone,
I'm trying to add a custom column in my query. The excel formula looks like this
But I know for a power query the syntax is different.Please Login or Register to view this content.
Can someone help me please.
Thank you,
-Justin
Hi Justin,
See the attached where I created some random times and then did a Power Query on the Excel.CurrentWorkbook. I used the conditional column build tool to do what I think you want.
See if you can open the attached.... You will need to save it to somewhere before opening it as the Power Query uses the currently SAVED file to work with. Step through my PQ steps and check my answer.
Keep asking if you need more help.
PowerQuery for Shift Number.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Marvin,
Thank you so much. I didn't realize there was a conditional column tool.
Super big help!
Hi Justin,
Thanks for the rep. I find most Excel users are afraid of Power Query and won't even try it. I think Excel is ahead of normal user needs with this new tool. There are a lot of problems that can use Power Query for the answer. Power Query is easier to use than VBA, but it will take a little time for users to see how easy and powerful it really is.
I just started using Power Query and I agree it is very useful and much easier than VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks