-
USERELATIONSHIP: Specifies an existing relationship to be used in the evaluation of a DAX expression. https://dax.guide/userelationship/ Watch now
-
CROSSFILTER: Specifies cross filtering direction to be used in the evaluation of a DAX expression. https://dax.guide/crossfilter/ Watch now
-
The TOPPERCENT function that exists in MDX is not available in DAX. But you can write a calculation item in DAX that performs the same calculation if you want! You need Power BI and Tabular Editor to create the same… Watch now
-
Did you know you can execute a DAX query… in Excel? It is way faster than a PivotTable when it comes to retrieving a large amount of data in a table format. Let’s see how it works and how to… Watch now
-
Learn the syntax and the use cases of the DEFINE TABLE statement in DAX. This syntax has been introduced in DAX since December 2020 and can be used in DAX queries only. Watch now
-
Learn the syntax and the use cases of the DEFINE COLUMN statement in DAX. This syntax has been introduced in DAX since December 2020 and can be used in DAX queries only. Watch now
-
There was nothing normal about this year, and we acknowledge that. Hoping in a better 2021, let’s review what happened in the DAX world, and what to expect in 2021. Links and more details in the related blog post: https://www.sqlbi.com/blog/marco/2020/12/31/what-has-happened-in-the-dax-world-in-2020/… Watch now
-
We have a new DAX Tools video course and it is FREE! The complete course is available here: https://www.sqlbi.com/p/dax-tools-video-course/ Watch now
-
Learn how to write a DAX query using TOPN to display the first elements in individual rows, grouping the remaining elements in a single “Other” row. The goal of the video is to show how to write a DAX query… Watch now
-
After you apply all the best practices to improve compression in Power BI, you can play with advanced settings to increase it further, even though this can affect certain features. Explore how to manipulate Encoding Hint and Available In MDX… Watch now