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

Hello AJP-PBIyou can use next construction: Calculate (Sum('Table'[Col Electricity]),FILTER('Table',MONTH('Table'[date])=MONTH(now())))

DAX to Filter by current month | Microsoft Fabric Community

katika555
Resolver I
3 years ago
Hello AJP-PBI
you can use next construction:

Calculate (Sum('Table'[Col Electricity]),FILTER('Table',MONTH('Table'[date])=MONTH(now())))
- MHZ
  New Member
  2 years ago
  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
    Resolver I
    2 years ago
    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())))
- dmfischer
  New Member
  2 years ago
  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!!!!!!
Anonymous
Not applicable
3 years ago
Hello katika555
Thanks a lot for the solution. It worked.