PBI - Power query - 如果某一列包含某值，则新列的值为此值的写法

Custom Column - Power query

如果Status列的值为“Act" or "Actual"，那新的列值为"Act“，否则为”OTHER STATUS“。

 if List.Contains( {"Act", "Actual"}, [Status] )  then "Act"  else "OTHER STATUS" 

 

 

 

 ref：https://gorilla.bi/power-query/if-function-in-power-query/#:~:text=IF%20Statements%20in%20Power%20Query%20%28Incl%20Nested%20IF%29,write%20conditional%20if%20statements%20in%20Power%20BI.%20