Tag: DAX Functions

CROSSJOIN DAX Function: Server Timings & Query Plan

CROSSJOIN DAX Function Server Timings & Query Plan - Enterprise DNA

In this tutorial, you’ll learn how the CROSSJOIN function works in DAX using the Server Timings pane and its query plan. The CROSSJOIN function can be used to create a Cartesian product of two tables. A Cartesian product is a set of all possible combinations of rows from two or more tables. The DAX code

Continue reading

UNION DAX Function Vs Power Query

UNION DAX Function Vs Power Query - Enterprise DNA

In this tutorial, you’ll learn a DAX optimization technique using the UNION function. This tutorial will compare the performance of the UNION function versus Power Query and other techniques for combining tables. The UNION function combines two tables into a single table by combining their rows and removing any duplicate rows. The example in this

Continue reading

Power BI Split Column By Delimiters In DAX

Power BI Split Column By Delimiters In DAX- Enterprise DNA

In today’s blog, you will learn how to use Power BI to split column by delimiters using DAX. This is something you would probably know how to do easily using Power Query, and that is generally the best way to do it.  But because of the dynamic nature of the problem and the specific considerations

Continue reading

DAX Query Example Using Various Keywords & Functions

Dax Query Example Using Various Keywords & Functions - Enterprise DNA

In this tutorial, you’ll learn about various keywords and functions in DAX Studio with a specific query example for each one. Specifically, you’ll learn about the ORDER BY and START AT keywords, along with the TOPNSKIP and ADDMISSINGITEMS functions. DAX Query Example: ORDER BY Keyword The ORDER BY keyword allows you to sort a dataset.

Continue reading

Optimizing DAX For Power BI Using DAX Studio – Formula Engines

When you’re optimizing your data model and your DAX for Power BI, it helps to remember that there are two engines running behind the scenes — the formula engine and the storage engine. These two engines work together to return the results needed back to the user. They provide the results set in the form

Continue reading