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...
Have you tried putting the follwing below?
if ([Course Name] = "Managing Information" or [Course Name = "Promoting Positive Workplace Behaviour")
And then repeat for each instance?
What was the response to this.
I have similar situation for a custom column, i need to have values
if col1=a1 and col2 =a2 then '50'
else col1=b1 and col2=b2 then 100
and so on for 20 values
how to resolve this
Hi Anonymous
You can create a new Custom Column in the Power Query Editor with the following syntax
if [col1] = "a1" and [col2] = "a2" then 50 else if [col1] = "b1" and [col2] = "b2" then 100 else if [col1] = "c1" and [col2] = "c2" then 200 else 999
- Please see content from @gilbertiq, that would suit your needs
