I have received some sales data from John, my favourite imaginary salesperson. He’s decided to merge some of his data. I have a list of companies on each line, instead of one row for each company. I want to have one row per company so that I can link to other company data. I start Read More
Category: Microsoft Office
How to Remove Duplicates by Using Power Query for Excel
Open up the Power Query Editor. Go to Home > Remove Rows > Remove Duplicates STEP 4: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the cleaned table. You now have your new table with the remove duplicates power query! This completes our tutorial on How to Remove Duplicates Read More
PERCENTILE vs PERCENTILE.INC vs PERCENTILE.EXC
PERCENTILE.EXC and PERCENTILE.INC differs only in the way the possibly-non-integer rank is calculated. For PERCENTILE.INC (and PERCENTILE) the calculated rank is K*(N-1)+1. For PERCENTILE.EXC the calculated rank is K*(N+1). Percentile Percentile is a statistics term used to describe the Nth observation in a data set after sorting in ascending order. For example, 40th percentile (P40) Read More
Import Data From a Folder with Multiple Files (Excel)
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of rows and values differ Read More
How to Build a Power BI Dashboard for Mobile Correctly
4 steps to build Power BI dashboard for Mobile correctly In this article, we will learn how to Optimize a Power BI dashboard for mobile phones. What is a Power BI dashboard? How to create a power bi dashboard for mobile phones? What is a Power BI dashboard? A Power BI dashboard is a feature of the Read More
How to Fix “Begins with”, “Ends With”, “Contains” Missing in Power Query Filter
If you use PowerQuery (if you don’t learn as quickly as possible), you may notice that in the filter, some of the options you want to use seem to be missing. So why is ‘ Begins with, Ends With, Contains ‘ missing from some PowerQuery filters? In the example below I want to remove any Read More