-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
-
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
-
This article describes how you can use a scatterplot visual to make more effective Power BI reports. Read more
-
We did it again! Yesterday, as an April Fool, we published an article written by ChatGPT-4 (Revolutionizing Power BI: Introducing the Ultimate Formula Language), which described better than I could have ever done the excitement for a new revolutionizing language:… Read more
-
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
-
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