Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts,
Is there a way to filter the count of records which has date which is future to the current date (taken from system) ?
The field name is "Date of Filing" having 1. Year 2. Quarter 3. Month and 4. Day
Thanks a lot
Solved! Go to Solution.
@acerNZ ,
countrows(filter(Table, Table[Date] >today()))
@acerNZ ,
countrows(filter(Table, Table[Date] >today()))
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |