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())))

     

     

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())))