Forum Discussion

Elisa112's avatar
Elisa112
Helper V
1 year ago
Solved

Count Rows for this month and between a specific range

Hi Experts I have a summarised table which I am trying to count the number of occurences for this month between a specific range of values for Active customers only   Here is my example data   C...
Need Help
  • vicky_'s avatar
    vicky_
    1 year ago

    Your measure is working fine for me - i just made some adjustment based on your sample data to only look at Jan 2024

    BTW - if your expected results are 3 for the sample data above, you'll need to use >= and <=

    I'm not sure what your actual data / report looks like, but you can check if you've got any other filters causing the result to be blank on your report by going to the top-right of the visual and checking there. 

     

vicky_'s avatar
vicky_
Super User
1 year ago

Your measure is working fine for me - i just made some adjustment based on your sample data to only look at Jan 2024

BTW - if your expected results are 3 for the sample data above, you'll need to use >= and <=

I'm not sure what your actual data / report looks like, but you can check if you've got any other filters causing the result to be blank on your report by going to the top-right of the visual and checking there. 

 

  • Elisa112's avatar
    Elisa112
    Helper V
    1 year ago

    Thanks, yes it works correctly