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

This article describes how to extract raw data stored in the Tabular engine, used by Analysis Service Tabular, Power BI, and Power Pivot.  Read more

The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property.  Read more

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

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

Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server.  Free download

DAX Date Template is a Power BI template file containing a fully-featured Date table. This template spares the user from writing the required DAX expression – as well as in setting the necessary properties to define display format, hierarchies, and…  Free download

DAX Editor is an extension to SSDT that makes it easier to edit DAX measures in a Microsoft Analysis Services Tabular project.  Free download

SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Server Data Tools for a Tabular model in compatibility version 1200 or later.  Free download

Professional BI developers using Analysis Services and advanced users working with Power BI share a common pain. Their productivity editing a large data model is much lower than what you might expect in 2017. There are many reasons for that.…  Read more