Topic: Power Pivot

        Page 2 of 248 posts
article –

How to handle BLANK in DAX measures

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could cause mistakes in a report using alternate expressions of the same calculation. Indeed, these expressions are not equivalent…  Read more

tool –

DAX Studio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and…  Free download

tool –

VertiPaq Analyzer

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. A complete description and short tutorial is available in the article Data Model Size with VertiPaq Analyzer.  Free download

tool –

Power Pivot Utilities

Power Pivot Utilities is an Excel add-in (based on a collection of VBA macros) that helps in documenting PowerPivot models and facilitates the creation of pivot tables connected to the data model.  Free download

blog post –

Why data modeling is important in #powerbi

I have a long experience in working on reporting systems based on semantic models. Now we call them “self-service BI”, but the principles are the same we had in DSS (decision support system), OLAP (on-line analytical processing), and many other…  Read more

article –

Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.  Read more

article –

Start learning DAX for free

SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course.  Read more