Tag: FILTER Function

Filter Function In Power Apps

In this tutorial, we’re going to talk about the filter function in Power Apps. The filter function is one of the most useful functions in the platform especially if you have a lot of data to deal with. It’s very similar to the search function, which we discussed in a previous tutorial. But we get

Continue reading

CALCULATE Function – How It Can Affect Your Calculations On Power BI

In this tutorial, I want to show you what the CALCULATE function can do through a few examples. CALCULATE is one of the most frequently used functions in Power BI. It dictates the context being applied to any measure and removes any existing filters in place. Using CALCULATE Function For Total Sales To truly understand

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

Power BI DAX ALL Function – How It Works

Power-BI-DAX-ALL-Function-–-How-It-Works

I want to give you a really quick introduction to the Power BI DAX ALL function. I find that there can be a bit of confusion around how this function works, and I want to simplify it and make it easy to understand. This tutorial will enable you to recognize where and when you should

Continue reading

Power BI Tips: Retrieving Previous Value Excluding Weekends & Holidays

Power BI Tips Retrieving Previous Value Excluding Weekends and Holidays

In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. The developer

Continue reading