follow.it gives you an easy way to subscribe to SQLBI's news feed! Click on Follow below and we deliver the updates you want via email, phone or you can read them here on the website on your own news page.
You can also unsubscribe anytime painlessly. You can even combine feeds from SQLBI with other site's feeds!
Title: Home - SQLBI
Is this your feed? Claim it!
Learn the differences between similar but different DAX functions that remove filters from the filter context.
DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions.
Computing values in DAX is all about understanding how to manipulate the filter context to obtain the desired output. DAX offers a wide variety of functions to manipulate the filter context, including a rich set d...
User-aware calculated columns are not materialized: we can use them as virtual calculated columns for localization and for custom security scenarios. This feature is available through the new Expression Context property of calculated columns in Power BI.
This article describes the new Expression Context property of calculated columns in Power BI, explaining how user-aware calculated columns work, why they are not materialized, and how to use them as virtual calculated columns for localization and custom security scenarios.
A calculated column is computed when the table is refreshed and stored in the model (in Impo...