# Topic: Power Pivot

Page 2 of 64 results
• # Compare equivalent periods in DAX

If you do not have a full month with data, comparisons such as year-over-year (YOY) might require particular filters in order to do a like for like comparison in DAX. This article describes how to write DAX expressions comparing equivalent…  Read more

• # Analyzing events with a duration in DAX

This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date and ship date.  Read more

• # Custom Year-Over-Year Calculation in DAX

This article describes how to implement a custom year-over-year calculation in DAX based on arbitrary associations between different periods. As an example, we describe the comparison of the 53rd week in a ISO Calendar.  Read more

• # Semi-Additive Measures in DAX

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements.  Read more

• # 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

• # Using GENERATE and ROW instead of ADDCOLUMNS in DAX

This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions.  Read more

• # Calculated Columns and Measures in DAX

One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one.  Read more

• # Physical and Virtual Relationships in DAX

DAX calculations can leverage relationships present in the data model, but you can obtain the same result without physical relationships, applying equivalent filters using specific DAX patterns. This article show a more efficient technique to apply virtual relationships in DAX…  Read more

• # 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

• # Linkback Tables in PowerPivot for Excel 2013

In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using the Linked Table feature. Excel 2013 expands this capability by  Read more