DAX to Filter by current month

[Anonymous]

Hello Data Enthusiasts,
I am trying to automate a measure. Actually, it's a filter part of the measure. 

Currently, I am using:

FILTER('Calendar','Calendar'[FinMnthYr]= "Nov-22"))

to filter the data for November month only.
But I want to make it automatic. So that measure filters the data for every current month.

Kindly help.

Regards,
AJP

[Anonymous]

Hello @katika555 
Thanks a lot for the solution. It worked.

[katika555 · Accepted solution]

Hello AJP-PBI
you can use next construction:

Calculate (Sum('Table'[Col Electricity]),FILTER('Table',MONTH('Table'[date])=MONTH(now())))

[dmfischer]

I've been reading support forums for several hours, yesterday and today, looking for a solution to why my date filter wasn't working inside a measure. This is the first suggestion that I've come across that is using (now()) instead of (TODAY()).  I tried it on my measure and it worked. I've been stuck for so long on this - thank you!!!!!!

[MHZ]

how to add year as well e.g. From date i dont know year as there are dates in the data for multiple year, above expression will not filter correctly if there are multiple dates i.e. multiple years

[katika555]

Hi,  
If you want current Year current month just add additional filter options:

Calculate (Sum('Table'[Col Electricity]),FILTER('Table',MONTH('Table'[date])=MONTH(now())&&Year('Table'[date])=Year(now())))