Don’t miss the upcoming free SQLBI live event on Friday, April 16, 2021! Join Adam Saxton, Alberto Ferrari, Patrick LeBlanc, and Marco Russo to discuss common mistakes in big data models. Proper data modeling will be a hot topic in… Read more
Rolling averages (a.k.a. moving averages or running averages) over time are useful to smoothen chart lines and to make trends more evident. This article shows how to compute a rolling average over 12 months, in DAX. Read more
This article introduces the new DAX syntax (March 2021) to support CALCULATE filter predicates that reference multiple columns from the same table. CALCULATE Context transition Evaluates an expression in a context modified by filters. CALCULATE ( <Expression> [, <Filter> [,… Read more
USERELATIONSHIP lets you temporarily change which relationship is active. Even though USERELATIONSHIP is easy to work with in measures, it can be challenging and give you inaccurate results when used in calculated columns. In this article, we describe the details… Read more