Forum Discussion

v_mark's avatar
v_mark
Icon for Helper V rankHelper V
4 years ago
Solved

Count all the next day

I have a simple problem to solve hope you can help me out.  Today is 1/10/2022. I need to count all the entries that are greater than today with the status of "Closed" only as shown in the ta...
General Comment
Show and Tell
Tips and Tricks
  • smpa01's avatar
    smpa01
    4 years ago

    v_mark 

    Measure = COUNTROWS(FILTER('Table','Table'[Change Date]>TODAY()&&'Table'[State]="Closed"))
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

v_mark 

Measure = COUNTROWS(FILTER('Table','Table'[Change Date]>TODAY()&&'Table'[State]="Closed"))