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 video, we see different versions of the same formula, adapting the code to non-additive measures if necessary.

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.