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.


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.