Formula for filtering out last month

[Mehedi]

Looking for help. How can filter out the last month data. 

The Formula used TODATE([DateTime_Out]) >= TODATE(DateTimeAdd(DateTimeFirstOfMonth(),-1,"months"))

I filter out 

[Felipe_Ribeir0]

Hi @Mehedi 

To filter out last month (and keep all other months), try this formula:

TODATE([DateTime_Out]) != DateTimeAdd(DateTimeToday(), -1, 'months')

To keep just what is greater or equal last month, thy this one

TODATE([DateTime_Out]) >= DateTimeAdd(DateTimeToday(), -1, 'months')

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[DataNath]

@Mehedi when you say you want the last month's data, do you want everything from 1 month ago to now (4th September to today), or you want all of the previous month i.e. September's data?

[Emmanuel_G]

@Mehedi 

In attachement the way of doing that.

[Mehedi]

Hi ! I am looking for previous month not last month from today. As Example: It oct month I will be having raw data till Jan-Sep so I need to filter only Sep month total.

[Emmanuel_G]

@Mehedi 

Find in attachement all steps of doing that.

Let me know if it is ok for you.