Show Current month Data in the Report (Without using Date Filters, Using Date Functions & Create Calculated field)

1) Drag the all required fields on to work area,

2) There is future data in the data set,  And we want to see only current month data, So we have filter the Future Data as well as previous Year & Months data.

3) The following syntax shows current month only.

Name: Current Month Sales

Syntax:

if year([Order_Date])= year(today()) and month([Order_Date])= month(today())

then ([Sales]) end

4) The above calculated field shows the Sales volume for current month, for rest of the months it will show nulls.

5) We can remove the nulls from the view by dragging the "Current Month Sales" field onto filters shelf,

6) Then select the "SUM" then select "Special Tab".

7) Now report shows only current month data ( I removed Sales Field from the view)