M / PowerQuery: Return / Display Rows in a Source / Table that meet certain Conditions

Hi All,

I am a former SQL-User. Unfortunately, my current employer lives behind the moon, and manages his Business Data in Excel, not SQL.

I am thus introducing myself to PowerQuery, so I can quickly visualize/display data from Excel Sheets in customizable reports.

Here is my first "success":

Please Login or Register  to view this content.

M-PowerQuery1.PNG

Ergo, I have managed to pull one column (the "region" column) and display it.

What I would like to do next is:

A) Display another column to the right of the "region" column. I have a column called "Postal Code" in the source. How would I display this second column?

B) Once A) is done, I would like to display only rows/records where "region" matches "APAC".

C) Once B) is done, I would like to add a second condition, to display only rows/records where "region" = "APAC" and "Postal Code" = 123


Thanks for any help on this! Also, if anyone has any references on the web explaining how to do this, im happy to have them.

Thanks!

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.