Tag: FILTER Function

Power BI Between Dates Working Hours Solution

Power BI Between Dates Working Hours Solution - Enterprise DNA

In today’s blog, I will demonstrate an approach to Access Analytic’s Start Stop Challenge where, using Power BI, between-dates total working hours will be calculated. You can watch the full video of this tutorial at the bottom of this blog. The task is to calculate the total number of hours for a staff member on

Continue reading

DAX CALCULATETABLE Vs FILTER Function

DAX CALCULATETABLE Vs FILTER Function - Enterprise DNA

Both CALCULATETABLE and FILTER are powerful tools for manipulating and analyzing data in DAX query, but they have some key differences that are important to understand. In this blog, we’ll go over the CALCULATETABLE function and its query plan in DAX studio, and understand how it differs from the FILTER function. By the end, you’ll

Continue reading

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