Topic: Power Pivot

        Page 6 of 244 posts
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

video –

Budgeting with PowerPivot

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources. In order to use these new features,…  Watch now

blog post –

Use FIRSTNONBLANK and LASTNONBLANK instead of MIN and MAX #dax

You are probably used to think to FIRSTNONBLANK and LASTNONBLANK as DAX functions related to time-intelligence calculations (usually for semi-additive measures ). However, these functions have a syntax and a behavior that can be useful in other scenarios.  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

blog post –

Customize period comparison in DAX #powerpivot #dax #powerbi

I have seen many different types of custom calendars implemented in Power Pivot, Tabular, and DAX. I also wrote several articles ( week based calendars and time patterns ). However, there is a scenario that is hard to manage with the classical approaches,  Read more