Number Functions

Number functions create and transform number values. They can be used for basic math or more complex transformations.

April 24, 2024

Rick de Groot

Mastering M: Which Power Query Functions to Learn and When

The Power Query M language features nearly 1000 unique functions, which ...

March 5, 2025

Rick de Groot

Generating Random Numbers in Power Query M

In this article, we will focus on creating random values in ...

November 21, 2023

Rick de Groot

Power Query Precision: Avoid Rounding Errors

Are you having trouble getting accurate results when doing calculations in ...

November 17, 2023

Rick de Groot

Master List.Accumulate in Power Query (Step-by-Step Guide)

Are you looking to perform an action repeatedly on your data? ...

August 18, 2024

Rick de Groot

Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

An ordinal number is a number that tells you the position ...

Receive the latest article in your mailbox

[mc4wp_form id="1565"]

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. Sign up

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

Blog Contact Privacy Policy