I have a data source that updates on the 15th day of the month for the month prior. The following calculated field filters out data for the current month:
IF MONTH([Date]) = MONTH(TODAY()) AND YEAR([Date]) = YEAR(TODAY())
THEN 1 ELSE 0 END
However, I would like to also filter out the data for the month prior when TODAY() is prior to the 15th of the month.
Can anyone help?
first make a calculation isMonthPriorToday
DATEDIFF('month',today(),[Order Date] ) != 0
and also a calculation isToday>15
DATEPART( 'day',today() ) > 15
finaly a filter
(not [isMonthPriorToday] and [isToday>15])
and keep the True values