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

Understanding LOOKUPVALUE

The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. This article provides full coverage of the LOOKUPVALUE internals, alongside several performance considerations.  Read more

DAX 101 –

Mark as Date table

Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required.  Read more

article –

Introducing LOOKUPVALUE

This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt.  Read more

article –

Distinguishing HASONEVALUE from ISINSCOPE

This article describes the differences between HASONEVALUE and ISINSCOPE, which are two useful DAX functions to control the filters and the grouping that are active in a report.  Read more

blog post –

7 reasons DAX is not easy

DAX is simple, but it is not easy. I cannot remember how many times I read this sentence on social media, attributed to me. For good reason: I have repeated this sentence at almost every classroom course I delivered over…  Read more

article –

Handling customers with the same name in Power BI

This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation without adding visible characters to make the names unique.  Read more