Topic: DAX
-
Compare different DAX formulas to add ten working days to a date in a Power BI calculated column. Alberto explores the options using DAX Studio and query calculated columns to compare the efficiency of different approaches. Watch now
-
This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the Date dimension. Read more
-
This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. Read more
-
Convert a “Top N and others” measure pattern into a calculation group that can be applied to any DAX measure in a Power BI model. Watch now
-
How to modify the basket analysis measure to compute the Sales Amount of orders that have both products selected? This unplugged video show how we analyze the problem and write the formula, testing the result and refining the code so… Watch now
-
This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. Read more
-
DAX Studio 2.16 has two new preview features: Show Debug Commas and Show XMLA Commands. With Show Debug Commas you enable a button to move commas from the end of a line to the beginning of the following line, which… Watch now
-
How to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Watch now
-
In this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Read more
-
Alberto answers a user comment asking how to hide calculation items when too many of them are selected in a report. Explore how we analyze the problem and find possible solutions. Watch now
