How to Compare to the Prior N Months with an IN Statement

In this tip, I show you how to use the IN function to find the prior 3 months. This could easily be extended to more months by adding more numbers into the IN function.

I then go on to show you how to compare the latest month sales to the average of the prior 3 months.

Download the workbook here - https://www.vizwiz.com/2021/07/in-function.html

tableaututorialworksheet