Use Power Query conditional column to filter by multiple columns and criteria
This beginners tutorial looks at excel power query and using it to filter data based on multiple columns. Add a conditional column and use it as a conditional index column. This can then be used to clean up, replace or filter data. Power query transformations are a powerful tool to speed up and automate your working in excel. Have you ever thought of using power query to apply condition filters? If not, watch this video and find out how! Overall, power query transformations help to speed up work in excel and for this trick advanced power query isn't needed.
This power query tutorial is one of our excel power query training videos - check them out and let us know what else you would like to see! We've already looked at topics like grouping data with power query and combining multiple tables.
You can also download the file from our Google Drive, if you'd like to follow along: https://docs.google.com/spreadsheets/...
0:00 Introduction
0:57 Copying data into excel
1:16 Text to columns
1:53 Formatting as table
2:10 Loading data to Power Query editor
4:22 Loading data back to excel
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our other videos and playlists - particularly relevant to this video are those on power query!
Excel for beginners: Power Query: • Excel for beginners: Power Query
Links to our specific videos on these topics on power query:
Clean up and transform data AUTOMATICALLY using POWER QUERY: • Power Query clean up data: automatica...
Split data in multiple columns into separate rows using POWER QUERY: https://studio.youtube.com/video/5yZe...
Group data automatically using POWER QUERY: • Group data in POWER QUERY: automatica...
Summarising data using POWER QUERY: • Combine tables in POWER QUERY. Automa...
VLOOKUP in Power Query: Power Query VLOOKUP or XLOOKUP alternative: • VLOOKUP in Power Query: Power Query ...
