Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NISH72
Helper IV
Helper IV

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
1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

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

View solution in original post

1 REPLY 1
Nolock
Resident Rockstar
Resident Rockstar

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors