Power Query (30)

Miguel Escobar Miguel Escobar

Logical Operators and Nested IFs in Power BI / Power Query

In the previous post I showed you guys how to create a conditional column in Power BI / Power Query using the UI and then just using the Power Query Formula language. In this post we’ll go over the available conditional operators and how to do Nested IFs in Power BI / Power Query.
Miguel Escobar Miguel Escobar

Conditional Logic: IF statement for Conditional Columns

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url).

If you come from Excel, you've probably seen or heard about the IF statements and its new sister the IFERROR.

I remember the first time that I saw a conditional chain like the picture below:

It looked WAY better as a diagram than as an Excel formula, nevertheless – it worked just fine inside of Excel.

The question is….how do Conditionals work in Power BI / Power Query? do we have an IF function? maybe an IFERROR? THIS is the blog post where I’ll cover this topic.

Miguel Escobar Miguel Escobar

Combine or Append Data in Power BI / Power Query: Main Concepts

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url).

I’ve previously done a series on Merge / JOIN operations (First Part here) and it’s now time to do one on Combine / Append operations.

so…How do you combine / append / stack tables with Power BI / Power Query?

There are multiple ways to accomplish this, but we’re going to start with the basics.

Authors

Recommended Topics

Powered by Publii - Open-Source CMS for Static Websites