Tag: DAX Calculations

DAX Query Optimization Techniques And Lessons

DAX Query Optimization Techniques And Lessons

This tutorial will discuss about DAX query optimization practices. You’ll learn what VertiPaq can do with caches to improve DAX performance and generate accurate results. VertiPaq Caches In DAX Calculations The first topic is the VertiPaq Cache. Before you run your queries, you have to clear the cache first because other users may not use

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

DAX Calculation Groups – Power BI Report for Problem Of The Week #7

DAX Calculation Groups – Power BI Report for Problem Of The Week #7

I’m going to talk about the solution I came up with for the 7th Problem of the Week. The problem required a dynamic report that uses multiple DAX calculation groups. You can watch the full video of this tutorial at the bottom of this blog. The Problem of the Week happens every 1st and 3rd

Continue reading

Distance And Bearing Calculation: Power BI Geospatial Analysis

Distance And Bearing Calculation- Power BI Geospatial Analysis

This tutorial aims to discuss how to calculate distance and bearing in Power BI and how to efficiently use them for geospatial analysis. You can find a lot of distance calculations on the web. For this demonstration, I’ll use a simplified example of a solution I needed to build for one of my supply chain

Continue reading

VertiPaq Analyzer Tutorial: Relationships & Referential Integrity

VertiPaq Analyzer Tutorial - Relationships and Referential Integrity

This tutorial will discuss the Relationships tab in the VertiPaq Analyzer in DAX Studio. You’ll learn how useful it is in identifying referential integrity violations which slow down your DAX codes. It helps you determine which table or column needs to be optimized and improved. Relationships Tab Tutorial In The VertiPaq Analyzer The Relationships tab shows all

Continue reading