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