Functions

Functions in Power Query apply an expressions on certain defined parameters. They allow you to simplify calculations and re-use logic.

November 19, 2023

Rick de Groot

3 Ways to Select List Items by Position in Power Query

Retrieving specific items from a list based on their position is ...

November 23, 2023

Rick de Groot

How to Remove Duplicates in Power Query M (Complete Guide)

In this article, we’ll explore how to remove duplicates in Power ...

November 23, 2023

Rick de Groot

Working Days between Dates in Power Query (DATEDIFF)

Do you need to figure out how many working days are ...

November 23, 2023

Rick de Groot

Calculate Nth Business Day From Date in Power Query

In this article, we’re going to show you step by step ...

November 23, 2023

Rick de Groot

Compute a Running Total by Category in Power Query

Are you looking to create Running Totals by Category in Power ...

October 3, 2023

Rick de Groot

Return Next Working Day in Power Query

You may want to use Power Query to return the next ...

November 17, 2023

Rick de Groot

How to use List.Generate to make API Calls in Power Query M

Have you ever wanted to make API calls directly in Power ...

Receive the latest article in your mailbox

About BI Gorilla

BI Gorilla is a blog about DAX, Power Query and Power BI. It was founded in 2018 by Rick de Groot with the goal to provide easy to understand resources to help you advance.

Latest Posts

M Language Function Reference

You can now find everything you need to know on the Power Query M language (syntax, examples, articles etc.) at https://powerquery.how/.

Newsletter

Free your mind, automate your data cleaning.

©️ 2023 BI Gorilla. Powered by Rocket.net, FlyingPress • Built on theme GeneratePress

Blog Contact Privacy Policy