Record · corpus.blog/posts/01a0c56e-050a-7303-9479-7ad5ba8acdc3

Power Query formulas (how to use them and pitfalls to avoid)

exceloffthegrid.com · published 18 October 2022

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at exceloffthegrid.com Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
External links: 3
Words captured: 2,287

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

docs.microsoft.com

https://docs.microsoft.com/en-gb/powerquery-m/power-query-m-function-reference

docs.microsoft.com

https://www.youtube.com/watch?v=p3hhUZwQGVE

youtube.com

Elsewhere on exceloffthegrid.com (19)

Introduction to Power Query Read at the source ↗

exceloffthegrid.com

Common Power Query errors & how to fix them Read at the source ↗

exceloffthegrid.com

How to get data into Power Query – 5 common data sources Read at the source ↗

exceloffthegrid.com

Refresh Power Query in Excel: 4 ways + advanced options Read at the source ↗

exceloffthegrid.com

Use the Power Query editor to update queries Read at the source ↗

exceloffthegrid.com

Get to know Power Query Close & Load options Read at the source ↗

exceloffthegrid.com

Power Query Parameters: 3 methods + 1 simple example Read at the source ↗

exceloffthegrid.com

Common Power Query transformations (50+ powerful transformations explained) Read at the source ↗

exceloffthegrid.com

Power Query Append: Quickly combine many queries into 1 Read at the source ↗

exceloffthegrid.com

Get data from folder in Power Query: combine files quickly Read at the source ↗

exceloffthegrid.com

List files in a folder & subfolders with Power Query Read at the source ↗

exceloffthegrid.com

How to get data from the Current Workbook with Power Query Read at the source ↗

exceloffthegrid.com

How to unpivot in Excel using Power Query (3 ways) Read at the source ↗

exceloffthegrid.com

Power Query: Lookup value in another table with merge Read at the source ↗

exceloffthegrid.com

How to change source data location in Power Query (7 ways) Read at the source ↗

exceloffthegrid.com

https://exceloffthegrid.com/power-query-if-statements

exceloffthegrid.com

How to use Power Query Group By to summarize data Read at the source ↗

exceloffthegrid.com

How to use Power Query Custom Functions Read at the source ↗

exceloffthegrid.com

https://exceloffthegrid.com/power-query-tips-and-tricks/

exceloffthegrid.com