A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order. Read more
This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Read more
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
This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Read more
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
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
Feb 3-5 - New York City
Feb 17-19 - Sydney
Marco Russo