Filtering to previous month

[richard_gardner]

Good Afternoon. I'm trying to create a dynamic filter that will filter the date/time to only the previous month. The data comes in as DateTime. I'm sure this is simple, but I can't seem to come up with a solution that works.  Suggestions?

[gfern2000]

Thanks you!!

This was just what I was looking for since there was no built-in function to do this.

[vpogaku]

Hi,

I want to calculate the YTD for a date column till previous month only but not till current date or month.

Can you please frame a logic on YTD as we want to calculate only till previous month end because we don't get complete current month data. So, our YTD should be calculating only till previous month. 

Thanks!