Topic: Power Pivot

       Page 4 of 63 articles
article –

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

article –

Costs of Relationships in DAX

The relationships in a data model queried by DAX are a fundamental part of the engine and simplify the query itself. This article examines the cost of relationships in a data model, providing hints to optimize them.  Read more

article –

Data Model Size with VertiPaq Analyzer

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.  Read more

article –

Parameters in DAX Measures

DAX is a functional language that does not allow you to create functions. However, if you need to pass a parameter to an algorithm, you can use a measure passing a value through a filter argument in CALCULATE, as described…  Read more

article –

Alternative use of FIRSTNONBLANK and LASTNONBLANK

You might have used FIRSTNONBLANK and LASTNONBLANK in semi-additive measures, but you might not be aware that their use is not limited to time intelligence functions. This article shows alternative scenarios where these functions are useful.  Read more

article –

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

article –

AutoExist and Normalization

The autoexist feature used by MDX queries sent to an Analysis Services or Power Pivot data models can have different behaviors depending on the normalization level. This article describes these differences and provides best practices to avoid unwanted results.  Read more

article –

Rolling 12 Months Average in DAX

Computing the rolling 12-months average in DAX looks simple, but it hides some level of complexity. This article explains how to write the best possible formula and how to avoid common pitfalls using time intelligence functions.  Read more

article –

Prepare Data for Power View Forecasting in Power BI

The new forecasting capabilities in Power View for Office 365 has certain requirements for the column used in x-axis. This article provides a guide to make your data model compatible with the new forecasting feature.  Read more