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 877 posts
article –

The IN operator in DAX

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value is included in a list of values or expressions.  Read more

blog post –

Mark as Date table in Power BI #dax #powerbi

One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI (I just updated the article including the example described below). In a recent event in Sydney I observed a strange (or at least unexpected) behavior  Read more

article –

Introducing SUMMARIZECOLUMNS

This article explains how to use SUMMARIZECOLUMNS, which is a replacement of SUMMARIZE and does not require the use of ADDCOLUMNS to obtain good performance.  Read more

article –

Compare equivalent periods in DAX

If you do not have a full month with data, comparisons such as year-over-year (YOY) might require particular filters in order to do a like for like comparison in DAX. This article describes how to write DAX expressions comparing equivalent…  Read more

article –

Using Process Add in tabular models

This article describes how to implement incremental updates to an Analysis Services database in Tabular mode with compatibility version 1200 or higher.  Read more