Forum Discussion

hongho2's avatar
hongho2
Frequent Visitor
3 years ago
Solved

syntax

Hi, For the syntax below, I want to set Staged column to Yes when status >15 else  No . However,I also want to set to No if  status is null or blank,  but don't know the syntax.  Can you assist ?  ...
Need Help
  • hnguy71's avatar
    hnguy71
    3 years ago

    Hi hongho2 , this should work:

     

    if Number.FromText([Status]) <= 15 or List.Contains({null, ""}, [Status]) then "No" else "Yes"
hongho2's avatar
hongho2
Frequent Visitor
2 years ago

it merged with other table, but the filter is in the same table.