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
Tag: DAX Studio
In this tutorial, we’ll go through a quick overview of all the options available in the user interface of DAX Studio. These include the panes and each button in the ribbon. We’ll discuss how using these features will help improve your performance in DAX Studio. It’s important to familiarize yourself with the purpose and function
In this tutorial, you’ll learn how to connect DAX Studio to Power BI and to the different variations of the SQL Server Analysis Services. This demo will go through four processes: Connecting DAX Studio to Power BI Connecting DAX Studio to the PowerPivot Model in Excel Connecting DAX Studio to SQL Server Analysis Connecting DAX
In this tutorial, you’ll learn how to download and install DAX Studio and Tabular Editor 3 in your computer, and how to configure them for use in Power BI and in Excel. This demonstration includes a detailed step-by-step instruction. Some points to remember are also included to ensure that you have a seamless experience when
In this tutorial, we are going to take a look at a very specific scenario that I’m sure all of you have already encountered while working with DAX – the expanded table. Expanded tables can mess up your calculation if you don’t know how they actually work. You can watch the full video of this