How to use Power Query to do SUMIF/COUNTIF and SUMIFS/COUNTIFS

In this video, you will learn how to use Power Query to perform SUMIF/COUNTIF and SUMIFS/COUNTIFS. These are powerful functions that allow you to summarize data based on certain criteria. For example, you can use SUMIF to find the total sales for a particular product, or COUNTIF to count the number of customers who live in a certain state. Power Query makes it easy to use these functions. Simply select the data that you want to summarize, and then use the SUMIF or COUNTIF function in the Power Query Editor. You can also use multiple criteria with SUMIFS or COUNTIFS. This video will show you how to use these functions in Power Query. By the end of the video, you will be able to use SUMIF/COUNTIF and SUMIFS/COUNTIFS to summarize your data in a variety of ways. Here are the steps on how to do SUMIF/COUNTIF and SUMIFS/COUNTIFS in Power Query: Open the Power Query Editor. 1) Import your data. 2) In the Power Query Editor, select the data that you want to summarize. 3) Click on the "Home" tab. 4) In the "Group By" section, click on the "SUMIF" or "COUNTIF" button. 5) Enter the criteria that you want to use in the "SUMIF" or "COUNTIF" dialog box. 6) Click on the "OK" button. Your data will be summarized based on the criteria that you entered. Here are some examples of how to use SUMIF/COUNTIF and SUMIFS/COUNTIFS in Power Query: - To find the total sales for a particular product, you would use the SUMIF function. In the SUMIF dialog box, you would enter the product name in the "Criteria" field. - To count the number of customers who live in a certain state, you would use the COUNTIF function. In the COUNTIF dialog box, you would enter the state name in the "Criteria" field. - To find the total sales for a particular product in a particular state, you would use the SUMIFS function. In the SUMIFS dialog box, you would enter the product name in the "Criteria 1" field and the state name in the "Criteria 2" field. I hope this helps!

Видео How to use Power Query to do SUMIF/COUNTIF and SUMIFS/COUNTIFS автора Управление данными в Power BI