Tag: CALCULATE and FILTER

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

A New Look At CALCULATE – Power BI

A New Look At CALCULATE – Power BI

In this tutorial, we’ll be looking at how to use the DAX function CALCULATE in Power BI. You can watch the full video of this tutorial at the bottom of this blog. CALCULATE is one of the most dynamic functions that can help you add deeper insights to your reports. But to truly understand it,

Continue reading

How To Use Simple Filters In Power BI

In this article, I am going to give you an overview of simple filters in Power BI. We have already done a few examples regarding this so it should not be too difficult to pick up. I am doing these demonstrations in tables for a good reason. It is easier to understand how formulas work

Continue reading

Showcase Insights Using The Multi Threaded Dynamic Visuals Technique In Power BI

This tutorial will cover how to use the Multi Threaded Dynamic Visuals technique to create insights from dynamic data visualizations in your Power BI reports. You may watch the full video of this tutorial at the bottom of this blog. It’s a valuable tool if you want to master Power BI because you can learn

Continue reading

Calculating Weekly Sales w/DAX In Power BI

Calculating the difference between weekly sales results in Power BI is unfortunately not that easy. You may watch the full video of this tutorial at the bottom of this blog. The reason behind this is that Power BI doesn’t have a weekly-based built-in time intelligence function. The only available options are for the day, month,

Continue reading