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...
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
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