We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis, with a focus on DAX and Data Modeling. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     160 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