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 the sample file here: https://www.sqlbi.com/tv/analyzing-th... Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged