Sum of previous two months sales where the current month is entered by the user

Question

I've a scenario, I need to calculate sum of sales of previous 2 months if I select any month. That is, my months are in parameter and if I select any month I should be able to sum previous 2 months sales. Can anyone help me to achieve this end result?

Answer 1

It can be achieved easily by creating a calculated field, here is how it goes:

1. Create a Parameter "Month_Paramater"
2. Choose Integer --> list

3. add list of values (e.g. 1 as January, 2 as February ..... so on till 12 as December)

4. Create a calculated field :

5. Use calculation:

   SUM(IIF(DATE_PART('month', [Order Date]) = [Month_Paramater] - 1 OR DATE_PART('month', [Order Date]) = [Month_Paramater] - 2, [Sales], 0))