Forum Discussion

bonjourposte's avatar
bonjourposte
Helper V
1 year 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
    1 year ago

    bonjourposte Maybe:

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

bonjourposte Maybe:

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