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

Instead of calculating, you could make PowerBi count the types.

And then just filter on the date.

Here is a visual with the date, and without the date appearing.