Operators

Operators are used in formulas to create expressions. Common operators concern Combination Operators (&), Logical Operators ( or, and, not), Number Operators (+, -, /, *, ) and List Record and Table operators

November 24, 2023

Rick de Groot

How to Concatenate Values in Power Query (Complete Guide)

In this article, you’ll learn how to concatenate values in Power ...

November 23, 2023

Rick de Groot

The COALESCE Operator in M / Power Query

In this article, you learn how to use the COALESCE operator ...

November 17, 2023

Rick de Groot

IF Statements in Power Query M (Incl Nested IFs, OR, AND)

In this article, we delve into the power of the IF ...

November 17, 2023

Rick de Groot

4 Ways to SUM Null Values in Power Query M

Trying to sum columns with null values in Power Query but ...

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