Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using COUNTROWS between a date range

Hi everyone   I have data with tickets that come in at various times, including multiple tickets on the same day. I am trying to ascertain repeat people who create tickets over the last 2 months. ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for your help Anonymous 

     

    I got there myself in the end, by using the FILTER function inside the COUNTROWS, it has got me the deisred results.

     

    Appreciate you spending the time.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

You can create a column to filter out data older than 2 months. 

 

Filter = 
var monthsdiff = DATEDIFF('Table (2)'[Created], NOW(), MONTH)

return if(monthsdiff <=2, "Show" , "Hide")

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your help Anonymous 

 

I got there myself in the end, by using the FILTER function inside the COUNTROWS, it has got me the deisred results.

 

Appreciate you spending the time.