Results 1 to 3 of 3

Thread: Filtering a column containing an Object in power query (Table, Binary)

  1. #1
    Seeker masterelaichi's Avatar
    Join Date
    Feb 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016

    Filtering a column containing an Object in power query (Table, Binary)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Is there a way to filter the Content column in power query to show only the rows that contain , say, Binary or Table?

    I tried the filter button on the column header but I don't get any options in the dropdown



    Click image for larger version. 

Name:	Filterobject.JPG 
Views:	38 
Size:	13.2 KB 
ID:	9461

    Appreciate any help

  2. #2
    Conjurer Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    103
    Articles
    0
    Excel Version
    Excel 365
    Code:
    = Table.SelectRows(PreviousStep, each [Content] is binary )

  3. #3
    Seeker masterelaichi's Avatar
    Join Date
    Feb 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016
    Thanks Bill!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •