Troubleshooting my "before this month" column

[Anonymous]

Hello Community -  This calculated column is giving me unexpected results.   Today is December 15 and I need the formula to register "true" for all dates prior to the current month.      Essentially, it is just a true/false column to allow me to filter out any months before the current month we are in.   Any suggestions?

[FreemanZ · Accepted solution]

hi @Anonymous 

try to add a column with this:

BeforeThisMonth = IF( FORMAT([Date], "YYYYMM") < FORMAT(TODAY(), "YYYYMM"), "Yes", "NO")

I tried and it worked like this:

[Anonymous]

@FreemanZ    Thanks for the reply...you solution works fine but I ended up going with this:    

IsCurrentMonth = IF(AND(MONTH('Table Name'[Date])=Month(NOW()),YEAR('Table Name'[Date])=YEAR(NOW())),1,0)