Tag: DAX tutorial

The Ultimate DAX Guide For Beginners

The third pillar in Power BI development is DAX calculations. This tutorial contains a thorough DAX guide for beginners covering the basics on formatting and editing. Frequently used DAX functions are also included in the discussion. DAX Editor Guide Before anything else, here are some DAX Editor tips you need to know: Use Ctrl +

Continue reading

New DAX Function COLUMNSTATISTICS – Overview

This tutorial will walk you through COLUMNSTATISTICS() – a new DAX function, which is almost entirely undocumented. It has been added to Power BI in August 2021. You can watch the full video of this tutorial at the bottom of this blog. This function can be used to quickly create metadata on every table in

Continue reading

DAX Measure Analysis: Breaking Down Long DAX Measures

DAX-Measure-Analysis--Breaking-Down-Long-DAX-Measures

In this tutorial, I’m going to show you some detailed DAX measure analysis on how I put together one of my favorite pages in the report I submitted for the 10th Power BI Challenge. The Rankings page uses a lot of challenging DAX measures. But with the help of one of our Enterprise DNA experts,

Continue reading

VertiPaq Analyzer In DAX Studio | Power BI Tutorial

VertiPaq Analyzer In DAX Studio | Power BI Tutorial

This tutorial will showcase the VertiPaq Analyzer Metrics in DAX Studio and how it helps in optimizing your DAX codes. Every metric will be discussed so that you’ll understand how each can help improve the performance of your codes. This is the VertiPaq Analyzer Metrics. Tables Tab Of The VertiPaq Analyzer The first metric is

Continue reading

VertiPaq Engine Power BI: An Introduction

VertiPaq Engine Power BI: An Introduction

In this tutorial, you’ll learn about the VertiPaq Engine feature in Power BI which will help boost the performance of your DAX code. This post is an introduction to the Storage Engine and what it does with your DAX. DAX Query Structure For VertiPaq Engine Firstly, you need to understand the query structure that happens

Continue reading