17 results
• # Checking Boolean conditions while creating a like for like comparison in DAX – Unplugged #36

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

• # Fixing “Top N and others” report when filtering by date – Unplugged #35

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

• # Implementing running total from arbitrary dates in DAX – Unplugged #34

Create a running total formula in DAX that starts from arbitrary dates instead of considering the complete history available.  Watch now

• # Differences between ALLSELECTED and KEEPFILTERS – Unplugged #33

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

• # Analyzing the last 6 months of sales from the last transaction of each customer – Unplugged #32

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

• # Adding working days to a date in DAX calculated column – Unplugged #30

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

• # Implementing the “Top N and others” pattern using calculation groups in DAX – Unplugged #28

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

• # Customizing the Basket Analysis pattern – Unplugged #27

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

• # New preview features in DAX Studio 2.16 – Unplugged #25

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 return 0 instead of BLANK in DAX

How to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data.  Watch now