Skip to content

BI Gorilla

  • Blog
  • Videos
  • Contact
  • About
BI Gorilla
  • Blog
  • Videos
  • Contact
  • About

Errors

If function in power query

Mastering IF Statements in Power Query – Including Nested IF-Statements

5th July 2022 by Rick de Groot Categories Power Query

The IF function in Power Query is one of the most popular functions. It allows you to make comparisons between a value and what you’re …

Read more

Categories Power Query

Stay in the Loop

Get the latest Excel and BI advice, tips and in-depth tutorials delivered straight to your inbox.

Microsoft MVP:

Subscribe to my Channel

Youtube subscribe button

Want Some Help

As well as being a blogger, I’m an independent consultant with a passion for Excel and Power BI. I have background in Finance and work with customers to find business solutions that increase insight and quicken decision making. I’d be happy to work on interim assignments.

For more details see:

Linkedin Image

Recent Posts

  • The IN Operator in M / Power Query
  • The COALESCE Operator in M / Power Query
  • Transform Column Names in Bulk in Power Query
  • Fix Last Refresh Date/Time in Power BI (Incl Daylight Savings)
  • List.Accumulate in Power Query (Explained with Examples)

Tags

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date Table DateTime.LocalNow Function Group By List List.Combine List.Contains List.Dates List.Distinct List.Generate List.MinN List.Numbers List.PositionOf List.Range List.RemoveFirstN List.RemoveItems List.RemoveMatchingItems List.RemoveNulls List.ReplaceMatchingItems List.Sum List.Union Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart

Categories

  • DAX
  • Excel
  • Power BI
  • Power Query

About BI Gorilla®

BI Gorilla is a free resource site for Excel and Power BI enthusiasts. BI Gorilla was founded in 2018 by Rick de Groot. The main goal of this site is to provide quality tips, tricks, hacks, and other resources that help you advance with Power BI and Excel.

RECENT POSTS

  • The IN Operator in M / Power Query
  • The COALESCE Operator in M / Power Query
  • Transform Column Names in Bulk in Power Query
  • Fix Last Refresh Date/Time in Power BI (Incl Daylight Savings)
  • List.Accumulate in Power Query (Explained with Examples)

TOPICS

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date Table DateTime.LocalNow Function Group By List List.Combine List.Contains List.Dates List.Distinct List.Generate List.MinN List.Numbers List.PositionOf List.Range List.RemoveFirstN List.RemoveItems List.RemoveMatchingItems List.RemoveNulls List.ReplaceMatchingItems List.Sum List.Union Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart

SOCIAL

  • YouTube
  • LinkedIn
  • Twitter

© 2022 BI Gorilla