If else in power query editor

[NISH72]

Hi I have a sales table with 3 columns
Salesid. Sales. Comment
1. 778. Good
2. 675
I want to populate only those rows in another table which will be edited in sales table. For eg if someone adds a comment in customer section only that particular row should be populated in another table. How to do this is power query. Please help

[Nolock · Accepted solution]

Hi @NISH72,

use the function Table.SelectRows.

Example: 

let
    Source = #table(
        {"SalesID", "Sales", "Comment"},
        {
            {1, 778, "Good"},
            {2, 675, null}
        }
    ),

    Result = Table.SelectRows(Source, each [Comment] <> null)
in
    Result