Forum Discussion

shaunguyver's avatar
shaunguyver
Helper III
7 years ago
Solved

Count values occurring between two dates

I have a column, 'Date', which gives a range of dates across 2018.   I have a second column, 'Type', which gives the type of event associated with that date. The values are either 'Open' or 'Closed...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Perhaps something along the lines of:

     

    Measure = 
COUNTX(FILTER('Table',MONTH([Date]) = MONTH(TODAY())-1 && [Type]="Open"),[Type])
Thim's avatar
Thim
Resolver V
7 years ago

Just to be sure.

 

Today is the 30th October 2018.

 

Does that mean you want to see the numbers of open and closed for the period 1st of september til today or from the1st October to today?