Topic: DAX
-
This video shows how to create a like for like comparison in DAX comparing equivalent periods, and how to correctly implement a Boolean condition in a calculated column. Indeed, the presence of BLANK values in a Boolean expression might produce… Watch now
-
This video describes how we answer a question about an article: this time we show how to use the “Top N and others” report when there is a filter by date. Watch now
-
Create a running total formula in DAX that starts from arbitrary dates instead of considering the complete history available. Watch now
-
While ALLSELECTED and KEEPFILTERS are two very different DAX filter modifiers, in certain scenarios they seem to be alternatives to obtain the same result. Starting from a case like that, we clarify the differences between the two using several practical… Watch now
-
Modify the formula of an article answering a reader question: How to compute the last 6 months of transactions using the last transaction date of each customer, using a range of dates that is different for every customer. In the… Watch now
-
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
-
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
-
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
