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
标签：Status,新列,Power,某值,Act,query,20in% From： https://www.cnblogs.com/watermarks/p/17239943.html