Filtering with Power Query

[Joe Shaer]

Dear all,

I am new to Power Query and was asked to do a multi-criteria filter in a dataset.

I have a dataset with several columns. I need to filter two columns: 'orderdate' 'city' column. I would like to filter-out or delete only the rows which contain 'orderdate' BEFORE April 2020 specifically for the City of 'Boston'.

How would I do this without needing to use a formula? Attached is the sample file

Thank you,
Joe

 

[vletm]

Joe Shaer
... new to Power Query ...
then this should be open in Power Query- forum ...
as You've read from Forum Rules.
>> moved to there <<

 

[Chihiro]

Load data to PowerQuery. Then enter Query editor.

Click on pull down menu beside column name.
Select Date/Time Filters and then "Custom Filter".


Then select "Advanced" and set OrderDate "AND" City criteria.


NOTE: This is just example of how to do it. Since I wasn't exactly sure what end result you wanted.

 

[p45cal]

See attached where:

let
    Source = Excel.CurrentWorkbook(){[Name="Sales_Data3"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"OrderDate", type date}, {"Region", type text}, {"City", type text}, {"Category", type text}, {"Product", type text}, {"Quantity", Int64.Type}, {"UnitPrice", type number}, {"TotalPrice", type number}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([City] = "Boston")),
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [OrderDate] < #date(2020, 4, 1))
in
    #"Filtered Rows1"

 

[Joe Shaer]

Thank you very much everyone!