# Topic: Power Pivot

Page 5 of 63 articles
article –

# Check Empty Table Condition with DAX

In DAX there are different ways to test whether a table is empty. This test can be used in complex DAX expressions and this short article briefly discuss what are the suggested approaches from a performance perspective.  Read more

article –

# FILTER vs CALCULATETABLE: optimization using cardinality estimation

A common best practice is to use CALCULATETABLE instead of FILTER for performance reasons. This article explores the reasons why and explains when FILTER might be better than CALCULATETABLE.  Read more

article –

# Natural Hierarchies in Power Pivot and Tabular

Creating a hierarchy in a Power Pivot or Tabular data model is very easy, but you might experience performance issues if the hierarchy is not “natural”. This article explains how to create hierarchies avoiding these problems.  Read more

article –

# Semi-Additive Measures in DAX (for Power Pivot)

Values such as inventory and balance account, usually calculated from a snapshot table, require the use of semi-additive measures. In Multidimensional you have specific aggregation types, like LastChild and LastNonEmpty. In PowerPivot and Tabular you use DAX, which is flexible…  Read more

article –

# USERELATIONSHIP in Calculated Columns

In a Power Pivot or Tabular model with inactive relationships, one can rely on the USERELATIONSHIP function to apply an inactive relationship to a particular DAX expression. Its usage is simple in a measure, but one might consider alternative syntax…  Read more

article –

# Handling Wrong or Missing Dates in Tabular

In the traditional star schema design of a Data Mart, you replace a missing, unknown or wrong date in the fact table with a dummy value in the Date dimension table. In Tabular, handling a Date table requires an existing…  Read more

article –

# Yearly Customer Historical Sales in DAX

With DAX you can calculate the sales of the first, second and third year of a new customer without any ETL. In this article you see how to implement this calculation with good performance.  Read more

article –

# Inventory in Power Pivot and DAX: Snapshot vs. Dynamic Calculation

You can implement the calculation of stock inventory over time in several ways in DAX. The xVelocity technology in Power Pivot and Analysis Services Tabular is so fast that you might considerboth dynamic calculation and snapshot based calculation  Read more

article –

# Grouping Transactions by Age of Customers in DAX

Grouping transactions by customers’ age requires a computation made row by row at transaction level. DAX offers an elegant solution using calculated columns, which is described in this article.  Read more

article –

# Checklist for Memory Optimizations in PowerPivot and Tabular Models

This article contains a short checklist of what you have to do in order to optimize the memory used by a data model in PowerPivot or in Analysis Services Tabular, including links to tools and resources that can help you…  Read more