{"id":182518,"date":"2024-03-29T10:38:00","date_gmt":"2024-03-29T09:38:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=182518"},"modified":"2024-03-10T14:44:12","modified_gmt":"2024-03-10T13:44:12","slug":"power-query-table-selectrows-how-to-clean-your-data","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data","title":{"rendered":"Power Query Table.SelectRows : How to clean your data?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"182518\" class=\"elementor elementor-182518\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ddad11e e-flex e-con-boxed e-con\" data-id=\"ddad11e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-347ebae elementor-widget elementor-widget-heading\" data-id=\"347ebae\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Power Query Table.SelectRows is a data cleaning function for Excel and Power BI. Find out all about the benefits of this tool, its use cases and how to master it!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e1ae0d elementor-widget elementor-widget-text-editor\" data-id=\"1e1ae0d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Whether in Microsoft Excel or Power BI, the Power Query tool has become a must-have for data cleansing, transformation and analysis.<\/p><p>It is an <a href=\"https:\/\/datascientest.com\/en\/etl-or-extract-transform-load-definition-and-use\">ETL (Extract, Transform, Load)<\/a> technology directly integrated into both software packages. It enables users to connect, transform and model data from a variety of sources, making it ready for analysis.<\/p><p>Its popularity with analysts and other Data Science professionals is mainly due to its powerful functions offering a <strong>wide range of possibilities.<\/strong><\/p><p>One of these functions is particularly useful for filtering and selecting data according to specific criteria:<strong> Table.SelectRows.<\/strong><\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI: Microsoft's Business Intelligence solution&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\" target=\"_blank\" rel=\"noopener\">Power BI: Microsoft&#8217;s Business Intelligence solution<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;DAX Power BI: all about the query programming language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\" target=\"_blank\" rel=\"noopener\">DAX Power BI: all about the query programming language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Dataflow Power BI: everything you need to know about the self-service ETL tool&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/dataflow-power-bi-everything-you-need-to-know-about-the-self-service-etl-tool\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/dataflow-power-bi-everything-you-need-to-know-about-the-self-service-etl-tool\" target=\"_blank\" rel=\"noopener\">Dataflow Power BI: everything you need to know about the self-service ETL tool<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Direct Query: All you need to know about this data query method &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\" target=\"_blank\" rel=\"noopener\">Power BI Direct Query: All you need to know about this data query method <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI license: What does it cost? &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-license-how-much-does-the-microsoft-solution-cost\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-license-how-much-does-the-microsoft-solution-cost\" target=\"_blank\" rel=\"noopener\">Power BI license: What does it cost? <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI vs. Tableau: Two tools &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau\" target=\"_blank\" rel=\"noopener\">Power BI vs. Tableau: Two tools <\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-46d52e7 e-flex e-con-boxed e-con\" data-id=\"46d52e7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ab08100 elementor-widget elementor-widget-heading\" data-id=\"ab08100\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is Table.SelectRows?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7103a54 elementor-widget elementor-widget-text-editor\" data-id=\"7103a54\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This<strong> Power Query<\/strong> function lets you filter the rows of a data table according to specific criteria. This is an invaluable tool for reducing the volume of data to be processed, eliminating unnecessary data or creating subsets to meet specific needs.<\/p><p>To understand its usefulness, let&#8217;s take the simple example of a dataset containing information on a company&#8217;s sales.<\/p><p><strong>Using Table.SelectRows,<\/strong> you can filter the data to select only those sales made in a given period.<\/p><p>For example, this could be just sales for the current year. This filtering reduces the size of the dataset to the bare essentials, allowing you to concentrate on information relevant to the <a href=\"https:\/\/datascientest.com\/en\/the-unit-test-in-data-analysis\">analysis<\/a>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8573e4 elementor-widget elementor-widget-image\" data-id=\"f8573e4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/table.selectrows1.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-835f481 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"835f481\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn more about Table.SelectRows<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3716a65 e-flex e-con-boxed e-con\" data-id=\"3716a65\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ee87a8f elementor-widget elementor-widget-heading\" data-id=\"ee87a8f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Advanced data filtering options<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f7f4e79 elementor-widget elementor-widget-text-editor\" data-id=\"f7f4e79\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Beyond basic filtering,<\/strong> Table.SelectRows offers many more advanced techniques. One of the most powerful features is the ability to filter data according to multiple criteria.<\/p><p>To take the example of a <a href=\"https:\/\/datascientest.com\/en\/quantitative-analysis-what-is-it-and-how-do-i-become-a-quant\">company&#8217;s sales dataset<\/a>, we might want to select only those sales made during the current year that exceed a certain threshold.<\/p><p>Simply use<strong> Table.SelectRows<\/strong> to easily combine these conditions to obtain the desired result. Let&#8217;s imagine a sales dataset containing information on products, sales dates, amounts and regions.<\/p><p><strong>The Power Query<\/strong> function offers the possibility of filtering out sales that meet a number of criteria, such as those made in the first quarter of the current year in the North region and valued at over 1,000 euros.<\/p><p>Another interesting technique is the use of the logical operators &#8220;and&#8221; (AND) and &#8220;or&#8221; (OR). Here again, these operators can be used to create complex conditions by combining filter criteria.<\/p><p>For example, it&#8217;s possible to select sales corresponding to one of two conditions: those made during the current year <strong>AND whose value is greater than 1000 euros, OR those made in the South of France.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ff54933 e-flex e-con-boxed e-con\" data-id=\"ff54933\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bfd9a4c elementor-widget elementor-widget-heading\" data-id=\"bfd9a4c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Custom functions in Table.SelectRows<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a4262d7 elementor-widget elementor-widget-text-editor\" data-id=\"a4262d7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In <strong>addition to its advanced options,<\/strong> a major strength of Table.SelectRows is the ability to use custom functions for filtering. This opens the door to considerable flexibility in data cleansing and transformation.<\/p><p>These custom functions allow you to form complex expressions to filter your data. You can create them directly in the <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">query editor,<\/a> or import them from external sources.<\/p><p>For example, you can create a custom function to filter out sales whose amount exceeds a given value. This function can then be used in <strong>Table.SelectRows<\/strong> to select the corresponding rows in your dataset.<\/p><p>This approach makes sense in many situations. Let&#8217;s imagine, for example, that you want to filter sales according to dynamic, user-defined criteria, such as the choice of minimum amount and region. A custom function could be the solution for maximum filtering flexibility!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ad73a8 elementor-widget elementor-widget-image\" data-id=\"5ad73a8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/table.selectrows2.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3800a18 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"3800a18\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Mastering Table.SelectRows<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d1abd14 e-flex e-con-boxed e-con\" data-id=\"d1abd14\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-41142d9 elementor-widget elementor-widget-heading\" data-id=\"41142d9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Performance optimization and error management<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3eab9c elementor-widget elementor-widget-text-editor\" data-id=\"d3eab9c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Clearly, efficiency is essential<\/strong> when cleansing and transforming data. This is particularly true when dealing with large quantities of information.<\/p><p>Fortunately, there are a number of ways to optimize <strong>Table.SelectRows performance.<\/strong><\/p><p>For example, be sure to apply filters that are as specific as possible to reduce the number of rows to be processed.<\/p><p>On the other hand, avoid overly general filters that select a large part of the data, as this can slow down the query.<\/p><p>If your data source supports indexes, you can also use them to speed up the search for rows matching your filter criteria.<strong> Indexes allow you to access data more quickly.<\/strong><\/p><p>If you only need a few columns in your query result, use Table.SelectColumns to limit the columns selected. This will reduce the amount of data transferred, considerably improving performance.<\/p><p>When working with real data, it&#8217;s not uncommon to encounter situations where errors can occur when filtering or <a href=\"https:\/\/datascientest.com\/en\/data-quality-10-mistakes-not-to-make\">transforming data.<\/a><\/p><p><strong>Filtering errors<\/strong> can occur when the criteria are not correctly defined, or when the data does not match the specified criteria. For example, an error may occur if you filter dates and some of them are in the wrong format.<\/p><p>Similarly, when data is missing from the source dataset, or when empty values are encountered, this can lead to errors during transformation.<\/p><p>To maintain the reliability of your ETL processes and guarantee high-quality data, it is imperative to detect and manage these errors effectively. Otherwise, the entire query may fail.<\/p><p>To avoid such an inconvenience, you can use the &#8220;Try&#8230; Otherwise&#8221; construct, which allows you to try an operation and handle any errors that may occur. For example, you can try to convert a date and specify an action to be taken in the event of an error.<\/p><p>You can also use Power Query custom functions for more specific management. This provides more granular control.<\/p><p>Finally, another strategy is to generate error reports recording all problems encountered during the ETL process. This enables subsequent analysis and facilitates resolution.<\/p><p>By anticipating and proactively managing errors, you can maintain stable processes and ensure data quality throughout the analysis chain.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a6fcf86 elementor-widget elementor-widget-image\" data-id=\"a6fcf86\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/table.selectrows3.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a488f12 e-flex e-con-boxed e-con\" data-id=\"a488f12\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2fa0776 elementor-widget elementor-widget-heading\" data-id=\"2fa0776\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion: Power Query Table.SelectRows, a powerful, customizable filter function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6512d8c elementor-widget elementor-widget-text-editor\" data-id=\"6512d8c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Power Query Table.SelectRows<\/strong> lets you filter data according to multiple specific criteria, helping you to clean up datasets quickly and efficiently.<\/p><p>To learn how to master Power Query and all its functions, you can choose DataScientest. Our Excel and <a href=\"https:\/\/datascientest.com\/en\/power-bi-service-how-to-create-a-learning-environment-for-training\">Power BI online training<\/a> courses will enable you to acquire this expertise in just a few days!<\/p><p>The Power BI training can be completed in 2 to 5 days full-time, or 30 days part-time. It is divided into two parts: one for beginners, the other for advanced users. You can take one or both of them, depending on your objectives and level.<\/p><p>In this course, you&#8217;ll learn how to analyze, transform, organize, model and analyze data with Power BI, and how to create dashboards. You&#8217;ll also discover more advanced concepts such as <a href=\"https:\/\/datascientest.com\/en\/power-query-m-switch-how-does-it-work\">Power Query M<\/a> and DataFlow, or the DAX language.<\/p><p>At the end of the course, you&#8217;ll receive the state-recognized &#8220;<strong>Analyzing Data with Microsoft Power BI<\/strong>&#8221; certification, and can also take the <strong>Microsoft PL-300 certification exam to become a Power BI Data Analyst Associate!<\/strong><\/p><p>The Microsoft Excel training course is designed for beginners and advanced users alike. You&#8217;ll benefit from three months&#8217; access to Excel, and learn how to handle all the software&#8217;s advanced functions.<\/p><p>In particular, you&#8217;ll discover automation macros, pivot tables, arithmetic and statistical functions, and various formatting techniques. This course includes the state-recognized TOSA RS5252 certification exam!<\/p><p>All our courses can be completed entirely by distance learning, and are eligible for funding options. Don&#8217;t wait any longer and become a <em>Power Query expert with DataScientest!<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e20d48 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0e20d48\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start a Power Query training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-eddac70 e-flex e-con-boxed e-con\" data-id=\"eddac70\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2f86f43 elementor-widget elementor-widget-html\" data-id=\"2f86f43\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is Table.SelectRows?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"This Power Query function allows you to filter the rows of a data table according to specific criteria. It's an invaluable tool for reducing the volume of data to be processed, eliminating unnecessary data or creating subsets to meet specific needs.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Advanced data filtering options\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Beyond basic filtering, Table.SelectRows offers a number of more advanced techniques. One of the most powerful features is the ability to filter data according to multiple criteria.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Custom functions in Table.SelectRows\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"In addition to the advanced options, a major strength of Table.SelectRows is the ability to use custom functions for filtering. It opens the door to considerable flexibility for data cleansing and transformation.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Power Query Table.SelectRows is a data cleaning function for Excel and Power BI. Find out all about the benefits of this tool, its use cases and how to master it! Whether in Microsoft Excel or Power BI, the Power Query tool has become a must-have for data cleansing, transformation and analysis. It is an ETL [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":182519,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Query Table.SelectRows : How to clean your data?<\/title>\n<meta name=\"description\" content=\"Learn how to streamline your data cleaning process using Power Query&#039;s Table.SelectRows function such as the ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query Table.SelectRows : How to clean your data?\" \/>\n<meta property=\"og:description\" content=\"Power Query Table.SelectRows is a data cleaning function for Excel and Power BI. Find out all about the benefits of this tool, its use cases and how to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-29T09:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-10T13:44:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/power-query-table.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"422\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query Table.SelectRows : How to clean your data?\",\"datePublished\":\"2024-03-29T09:38:00+00:00\",\"dateModified\":\"2024-03-10T13:44:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\"},\"wordCount\":1273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\",\"name\":\"Power Query Table.SelectRows : How to clean your data?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-29T09:38:00+00:00\",\"dateModified\":\"2024-03-10T13:44:12+00:00\",\"description\":\"Learn how to streamline your data cleaning process using Power Query's Table.SelectRows function such as the ...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query Table.SelectRows : How to clean your data?","description":"Learn how to streamline your data cleaning process using Power Query's Table.SelectRows function such as the ...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data","og_locale":"en_GB","og_type":"article","og_title":"Power Query Table.SelectRows : How to clean your data?","og_description":"Power Query Table.SelectRows is a data cleaning function for Excel and Power BI. Find out all about the benefits of this tool, its use cases and how to","og_url":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-29T09:38:00+00:00","article_modified_time":"2024-03-10T13:44:12+00:00","og_image":[{"width":768,"height":422,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/power-query-table.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query Table.SelectRows : How to clean your data?","datePublished":"2024-03-29T09:38:00+00:00","dateModified":"2024-03-10T13:44:12+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data"},"wordCount":1273,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data","url":"https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data","name":"Power Query Table.SelectRows : How to clean your data?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-29T09:38:00+00:00","dateModified":"2024-03-10T13:44:12+00:00","description":"Learn how to streamline your data cleaning process using Power Query's Table.SelectRows function such as the ...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-table-selectrows-how-to-clean-your-data"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182518"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=182518"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182518\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/182519"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=182518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=182518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=182518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}