While it’s fairly common to need to load fixed-width files using Power Query or Power Query (and there’s a nice walkthrough of how to do this here), occasionally you might want to use Power Query and ...

An article that demonstrates how to create a custom column in Power Query using the Power Query M formula language. If you need more flexibility for adding new columns than the ones provided out of ...

Split Column (by Delimiter/Number of Characters) into rows. Basic mode for Group By operation. Extract Text Before/After/Between Delimiters. Unpivot Only Selected Columns. Combine Files ...

Adding an index column in Power BI To make this work, we must add a new column and populate it with the right values. Specifically, we’ll run a query that will add an index column.

Power Query for Excel 365 for Macs is being developed. These users are able to refresh queries but do not yet have the ability to author them in the Power Query Editor. The content of this article is ...

While it’s fairly common to need to load fixed-width files using Power Query or Power Query (and there’s a nice walkthrough of how to do this here), occasionally you might want to use Power Query and ...

With Power Query, you can add a conditional column to your query by defining IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column automatically displays the ...