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

发布时间 2023-03-22 21:11:39作者: po-A

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