Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX to Filter by current month

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 ...
Need Help
  • katika555's avatar
    katika555
    3 years ago

    Hello AJP-PBI
    you can use next construction:

     

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

     

     

katika555's avatar
katika555
Icon for Resolver I rankResolver 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's avatar
    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's avatar
      katika555
      Icon for Resolver I rankResolver 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's avatar
    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!!!!!!