Forum Discussion
AND IF in conditional column
Hi, I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns. What I'm looking for is something like this: If [COUNT...
Hi there
Will it have the individual number in the column?
If not if you could post some sample data of what the column currently looks like
Will it have the individual number in the column?
If not if you could post some sample data of what the column currently looks like
GilbertQ please see screen shot of the excel table below. The column in black is the one I have issues with. This column comes with a letter instead of those numbers. Let me know if you require more info
Hi there
Thanks for the screenshot.
What you could do, is go into the Power Query Editor, click on Add Conditional Column from the Add Column Ribbon.
Then you can use the conditional logic in which you can put in your requirements as shown below.
GilbertQ, YES, this solved the issue. I expect to ge to the calculations and hope everything goes well.
Thank you VERY much for your assistance on thisRegards
Rodrigo