Month Selection

[alexbalazsalex]

Hi All could you help me with the below formula?

FILTER('Test1','Test1'[Month]=DATE(2018,2,1))

I tried the below but it s not working :

FILTER('Test1','Test1'[Month]=DATE(2018,month(today()-2),1))  = it s givign me 0.

to have an ideea i get the results each month for 2 months ago so it s complicated to manually change the date every month as the formula is long

Any Ideas ?

[alexbalazsalex]

The "month" column in my db is giving me a full date 2/1/2018 (mm/dd/yyyy)

[alexbalazsalex · Accepted solution]

Dear All,

This is how i made it work in case anyone will have the same issue :

=FILTER('Test1','Test1'[Month]=EOMONTH(today(),-3)+1)) 

Regards