Hello Alex,

Are you looking for this:

1. Current month = DATETRUNC('month',TODAY())

2. Last month = DATEADD('month',-1,[Current month])

3. 2nd last month = DATEADD('month',-2,[Current month])

4. avg sales for last month = AVG(if DATETRUNC('month',[Order Date])=[Last month] THEN [Sales] END)

5. avg sales for 2nd last month = AVG(if DATETRUNC('month',[Order Date])=[2nd last month] THEN [Sales] END)

If this post helped you to solved your query, please mark it as CORRECT and HELPFUL.

Hello Alex Martino

This is for follow up. If your query is solved. Please mark my answer as correct and useful.

If not, please post your query here.

Hello Alex,

You can replace "Today" with MAX([Date]).