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
Tag: FILTER Function
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
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
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
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