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
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
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
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.
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
