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.
     845 posts
article –

Using OR conditions between slicers in DAX

This article describes how to implement in DAX a logical OR condition between the selection of two slicers of a Power BI report or of a PivotTable in Excel. By default, when relying on more than one slicer they are…  Read more

article –

Expanded tables in DAX

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code.  Read more

blog post –

International year_end_date for YTD functions in DAX

If you used the DATESYTD and TOTALYTD functions in DAX, you might have noticed that the optional parameter year_end_date is a string defining the last day of the year. The default is December 31, so this parameter is used only…  Read more

article –

Capturing Power BI queries using DAX Studio

This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries.  Read more

blog post –

Two weeks, two countries, two conferences, one family

In the last week, I have been speaking at two different events in a few days: SQLBits 2018 in London, UK and SQL Konferenz 2018 in Darmstadt, Germany. These two events created for SQL Server professional are now “polluted” by…  Read more

article –

Reference Date Table in DAX and Power BI

This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page.  Read more

blog post –

The new Data Modeling for Power BI course

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have more than one table, you usually have relationships between tables. When you analyze data, you often have many choices…  Read more

article –

The definitive guide to ALLSELECTED

ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED.  Read more

blog post –

Power Pivot Utilities 1.09

Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities, which allows the visualization of Dependents and Precedents measures in the measure list created by the List Measures tool. How to use the new…  Read more