DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4 After gaining an overview and performing the preparation for the four-parts of this article in Part 1, we introduced the COUNTROWS() function in Part 2. Then, in Part 3, we explored another DAX function, FILTER(). As we shall see in this, Part 4, of our...
Tag: column
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...
Tips for using SQL Server 2012 indexed views
Tips for using SQL Server 2012 indexed views One of the ways to optimize SQL Server 2012 performance is using indexed views. You can improve performance by creating a unique clustered index on the view, if the view is frequently referenced in queries that involve complex processing, such as aggregating lots of data or joining many rows. After creating a...