Forum Discussion
add a column in powerquery
Hi guys, How can I add a column in powerquery base on two other columns?
when col1=c3 and col2= sen then the value is 'Sen', else the value is col1?
Anonymous , New column in power Query
if [col1]="C3" and [col2]= "senior" then "C3(Sen)" else [col1]
1 Reply
- amitchandak
Super User
Anonymous , New column in power Query
if [col1]="C3" and [col2]= "senior" then "C3(Sen)" else [col1]