Forum Discussion

shaunguyver's avatar
shaunguyver
Icon for Helper III rankHelper III
7 years ago
Solved

Count instances occurring between fixed date and today

I have a table, 'Risks'.   In this table I have a column, 'Date', which gives a range of dates across 2018.   I also have a second column, 'Type', which gives the type of event associated with th...
Need Help
Show and Tell
  • Christann's avatar
    Christann
    7 years ago

    Try something like this:

    OpenEvents =
CALCULATE (
    COUNTA ( Table1[Type] ),
    Table1[Date] >= DATE ( 2018, 1, 1 ),
    Table1[Date] <= TODAY (),
    Table1[Type] = "Open"
)

     

Christann's avatar
Christann
Icon for Advocate IV rankAdvocate IV
7 years ago

Try something like this:

OpenEvents =
CALCULATE (
    COUNTA ( Table1[Type] ),
    Table1[Date] >= DATE ( 2018, 1, 1 ),
    Table1[Date] <= TODAY (),
    Table1[Type] = "Open"
)