1 of 1 people found this helpful
You can create an integer data type parameter with values 1 to 12 and display as names from jan to dec like this:
Then create 2 calcs for your expense and revenue, in my example I used sales and profit:
Profit Calc: IF datepart('month', [Order Date]) <= [Date Part Select] then [Profit] END
Sales Calc: IF datepart('month', [Order Date]) <= [Date Part Select] then [Sales] END
Where order date is your date dimension. Now selecting march in the parameter would give the expected output!