We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     Page 10 of 858 posts
article –

Using ALLEXCEPT versus ALL and VALUES

This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in Power BI and SSAS 2016.  Read more

blog post –

Q&A from 24 hour of PASS #pass24hop #powerbi

One week ago I delivered a session for 24 hour of PASS, the online free event delivered by PASS ( recordings are now available ), where I introduced my one-day preconference Create a Power BI Solution in one day that I will deliver at PASS Summit 2016  Read more

blog post –

BLANK and Boolean functions like IF in #dax

A recent change in the DAX language transformed the behavior of IF statement, so that it should not return BLANK but only TRUE/FALSE if the results should be logical expressions. In that case, the BLANK is transformed in a FALSE condition. For example,  Read more

article –

Adding a measure to a Tabular model

This article describes how to add a measure to a Tabular model already deployed on Analysis Services by using C# or PowerShell. This can be useful to deploy user-defined metrics without deploying the entire database.  Read more

article –

Tuning query limits for DirectQuery

This article describes a few query limits existing in DirectQuery for both Power BI and Analysis Services Tabular 2016, explaining when you can modify them.  Read more

article –

DAX coding style using variables

This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code.  Read more