Excel

The Power Query Column from Example feature is a powerful tool that allows you to define input columns from a data set and provide examples of desired outcomes. Power Query takes the user provided output examples and works backwards to generate Power Query M code to generate a new custom column. We’ll explain how to […]

Removing Null or Blank Rows in Power Query can help users avoid errors and presenting empty data. Power Query provides a couple of different options from removing empty rows to using a filter to effectively remove them from the dataset going forward. With either method, when Power Query is closed and refreshed the data will

You can either create a Custom Column in Power Query using Power Query M to calculate the difference between two date columns, or you can use Power Query’s Column from Example feature to let the software generate the formula to determine the number of periods between two dates for you. Column Data Types Matter Before

The fastest way to Extract Text from a string in Power Query is the Extract feature. It provides several pre-made settings to extract text from strings under common scenarios. For more control over the text extraction process you can also use Power Query M Formulas. The Power Query Extract Text Feature To access the Extract

Data types play a crucial role in Power Query. They determine how data columns are interpreted and how various formulas and operations are applied. Converting Text to Numbers in Power Query is one of the most common, especially when working with csv files or other flat file formats. We’ll explain why you should care about

Power Query has features to split columns by delimiter, number of characters, position along with several other options that gives developers a high level of control when splitting columns into multiple columns without having to write any special formulas. Splitting Columns in Power Query From the Power Query Editor navigate to the Split Column button

The traditional Excel import wizard has been disabled in newer versions of Excel by Microsoft in favor of having users utilize Power Query to import data and transform it prior to loading it into an Excel workbook. We’ll explain what the differences are and how to enable the traditional interface that many are used to

Power Query in Excel is prone to a number of display issues. The most common one represents as buttons that are too big, text that is too small, and the Power Query Ribbon seems shifted out of place. While this issue typically occurs on high-resolution monitors it can also occur when switching from a laptop

Working with first and last names in Power Query is a fundamental skill. Whether you’re parsing them from a single column, or combining multiple columns into one for easier readability, Power Query gives users multiple methods to complete data transformation quickly and efficiently. Working with first and last names in Power Query is a great