blog post –

The hard truth in numbers

We all have biases. Personally, I kick myself whenever I identify that I have applied my biases when doing an evaluation of any kind. Unfortunately, this happens often because I work with numbers every day. Do you think we at…  Read more

DAX Patterns

Related distinct count

The Related distinct count pattern is useful whenever you have one or more fact tables related to a dimension and you need to perform the distinct count of column values in a dimension table only considering items related to transactions…  www.daxpatterns.com


Book – SQLBI Corp.

DAX Patterns, Second Edition

A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.
Read more