Forum Discussion
Date Filter
Hello, I have requirement where I want to fetch the count of the values in each quarter as "Due in Current Quarter" . For exmaple , Please consider the below table : Name Date of Birth Tom ...
Thanks ! Its really complicated . Could you help me with a simplified DAX query . Let me reiterate my question again :
I have a requirement where I need the data which are due in current quarter . For example ,
| AIID | Application Name | Next DR Scheduled |
| 12345 | X | 27th Jan 24 |
| 43276 | Y | 02nd Mar 24 |
| 86531 | Z | 8th Mar 24 |
| 78856 | W | 28th Feb 24 |
Here in the above table it shows the DR date for X is already completed . Now we are in month of February 24 and we have 3 more DRs to be performed . Hence, If someone asks how many DRs are due for current month , it should be 3 . So, I need to dynamically either have a date filter applied or add a measure to achieve .
Please suggest .
You can add the 'Date Filter' column in a slicer, select 'Due in current quarter' and, in a visual, add a measure with a simple COUNT.