Forum Discussion

bonjourposte's avatar
bonjourposte
Helper V
2 years ago
Solved

Which DAX function do I use for this count?

I'm counting every time a status changed in the past MONTH.  Our periods run from the last day of the month, to the previous last day of the month.  So our Accounting date column has August 31, 2024;...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    bonjourposte Maybe:

    Measure = 
  COUNTROWS( FILTER( 'Table', [PreviousMatDateCC] <> BLANK() ) )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

bonjourposte Maybe:

Measure = 
  COUNTROWS( FILTER( 'Table', [PreviousMatDateCC] <> BLANK() ) )