Tag: Variables

Create Variables On Power Apps: Working With Collections

In this tutorial, we’ll be talking about the third type of variables called collections. Collections are helpful if you want to create variables on Power Apps that are more comprehensive than contextual and global variables. We talked about contextual and global variables on a different tutorial. Contextual variables are straightforward variables that can only be

Continue reading

PowerApps Variables: Identifying Contextual And Global Variables

In this tutorial, we’re going to learn about PowerApps variables and the contribution that they can make to our app. A variable is any element that can be counted or measured. PowerApps variable come in three forms — contextual variables, global variables, and collections. We’ll be discussing contextual variables and global variables in this tutorial.

Continue reading

Nested Expressions: Power Query Environments

Nested Expressions: Power Query Environments

In this tutorial, you’ll learn about nested expressions, objects, and environments in Power Query. Nested expressions and variables will be used to discuss how Environments work and help generate data. You’ll also learn to deal with common scenarios when transforming nested objects. Creating Nested Expressions Expressions are defined as a formula used to construct value.

Continue reading

DAX Queries Using Variables And Important Functions

DAX Queries Using Variables And Important Functions

This tutorial will discuss about variables, including the FILTER and CALCULATE functions. You’ll understand how these help boost the performance of your DAX queries and provide accurate results. Variables should be used as much as possible because they can easily locate codes for optimization. They prevent you from getting incorrect outputs and save you time

Continue reading

How To Work Through Extensive DAX Formulas In Power BI – Formatting Tips Included

How To Work Through Extensive DAX Formulas In Power BI – Formatting Tips Included

I’m going to show you how to work through complex DAX formulas. Extensive DAX formulas in Power BI are normally used if there are unique insights that you want to show on your reports. You can watch the full video of this tutorial at the bottom of this blog. One example of a scenario where

Continue reading