Tabular

ARTICLE

Context Transition and Filters in CALCULATE

This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid unexpected results with complex calculations made in filter arguments.

ARTICLE

What has happened in the DAX world in 2017

We are approaching the end of 2017, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2018. New DAX functions in 2017 Microsoft released ten new DAX functions in

ARTICLE

Computing same product sales in DAX

This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignoring products introduced afterwards.

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 when BLANK is involved.

ARTICLE

Querying raw data to Tabular

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

ARTICLE

Controlling drillthrough using Detail Rows Expressions in DAX

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.

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 formatting, integrated tracing and query execution breakdowns.

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.

TOOL

Tabular Editor

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

TOOL

DAX Editor

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