Author: Enterprise DNA Experts

The TABLE Keyword In DAX Studio: Basic Examples

The TABLE Keyword In DAX Studio Basic Examples - Enterprise DNA

In this tutorial, you’ll learn about the TABLE keyword in DAX Studio. The TABLE keyword allows you to create tables inside your DAX query. This is a continuation of a series of tutorials on the different keywords that you can use when creating DAX queries. Before diving into this topic, make sure to read first

Continue reading

Overview Of The DAX Studio Keyword COLUMN

Overview Of The DAX Studio Keyword COLUMN - Enterprise DNA

Another important keyword to learn when using DAX Studio is the COLUMN keyword. In simplest terms, the COLUMN keyword allows you to create and mimic a calculated column in DAX Studio. The following examples are a few of the ways you can use COLUMN in your codes in DAX Studio. Basic Example For this example,

Continue reading

The DAX Studio MEASURE Keyword: An Overview

The DAX Studio MEASURE Keyword: An Overview - Enterprise DNA

In this tutorial, we’ll look at the DAX Studio Keyword, MEASURE. Before diving into this topic, be sure to read first on the EVALUATE and DEFINE keywords. The example query used in this tutorial is a continuation of these two keywords. Ideally, the base measure shouldn’t be written as COUNTROWS for the Sales Table. Instead,

Continue reading

How Data Segmentation Works In Power BI

How Data Segmentation Works In Power BI - Enterprise DNA

In this tutorial, you’ll learn about the basic concepts of data segmentation in Power BI and SSAS. Specifically, you’ll learn about the operational definition of data segmentation and its advantages. An Overview On Data Segmentation When you import data in Power BI, you need to click the Close & Apply option. In the case of

Continue reading

Format DAX Codes Using DAX Studio’s Special Features

Format DAX Codes Using DAX Studio's Special Features - Enterprise DNA

In this tutorial, we’ll take a look at three special features in DAX Studio that help you format your DAX codes. These are the Debug Commas, DAX Format Query, and Comments options. They’re very useful in optimizing DAX codes and improving code readability. Detailed examples are given below to help you visualize and better understand

Continue reading