Forum Discussion

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
7 years ago
Solved

If else in power query editor

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
Need Help
Show and Tell
  • Nolock's avatar
    Nolock
    7 years ago

    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

1 Reply

  • Nolock's avatar
    Nolock
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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