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 that it should have relatively good performance.
The process takes time, errors can be made and the process of diagnosing the code that is not working is fully exposed in this uncut video.

Download

Insert your email address and press Download for access to the files used in this video.

Keep me informed about BI news and upcoming articles with a bi-weekly newsletter (uncheck if you prefer to proceed without signing up for the newsletter)

Send me SQLBI promotions (only 1 or 2 emails per year)

By downloading the file(s) you are agreeing to our Privacy Policy and accepting our use of cookies.