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