Forum Discussion

Dasbas's avatar
Dasbas
Frequent Visitor
9 years ago
Solved

How to count values at a certain date

Hello,   I am trying to create a dashboard for a service call system. In this system I have a Call date (open date) and a Close date. What i want to do is create a line graph which shows at what ti...
Need Help
  • LaurentCouartou's avatar
    LaurentCouartou
    9 years ago

    I forgot to mention a date should only appear once in your Dates table.

     

    Regarding the filter expression, I made a copy and paste error.

     

    [Number of calls opened at] = CALCULATE( COUNTROWS( Calls )
      , FILTER( VALUES( Calls[opendate] )
                ,  [opendate]  < MAX( Dates[date] )
      )
      , FILTER( VALUES( Calls[closedate] )
                ,  [closedate]  >= MAX( Dates[date] )
      )
)

     

LaurentCouartou's avatar
LaurentCouartou
Icon for Solution Supplier rankSolution Supplier
9 years ago

I forgot to mention a date should only appear once in your Dates table.

 

Regarding the filter expression, I made a copy and paste error.

 

[Number of calls opened at] = CALCULATE( COUNTROWS( Calls )
      , FILTER( VALUES( Calls[opendate] )
                ,  [opendate]  < MAX( Dates[date] )
      )
      , FILTER( VALUES( Calls[closedate] )
                ,  [closedate]  >= MAX( Dates[date] )
      )
)

 

Dasbas's avatar
Dasbas
Frequent Visitor
9 years ago

Thank you!