-
Exciting news has just landed in the Power BI universe, and it’s set to transform the way we write formulas forever! Read more
-
This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. Read more
-
Last week, we released the first open-source library to obfuscate VPAX files: the Vpax-Obfuscator, also available as a NuGet package and as a command line tool (CLI). Read more
-
Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at the model level. Read more
-
This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. Read more
-
This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context. Read more
-
If you use Power BI Desktop and want to know the version of the engine that you use and/or the compatibility levels supported, you can run the following DMV query: SELECT * FROM $SYSTEM.DISCOVER_PROPERTIES WHERE [PropertyName] = 'ProviderVersion' OR [PropertyName]… Read more
-
The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing this behavior is the next step in learning DAX once you understand row context and filter context. This… Read more
-
I am glad to announce that Kurt Buhler has started to work with us at SQLBI – we just published his first article and video, Improving data labels with format strings. Now that the cat is out of the bag,… Read more
-
DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your… Read more