Forum Discussion
Post PartisanNeed help with a date measure please
Hi, if I want to get a count of the days with no Date Completed date between 03/06/2024 and 01/09/2024, what would that look like? I want a card to show the number 2 please.
| Customer Number | Date Reported | Date Completed |
| 1 | 01/04/2024 | 01/04/2024 |
| 2 | 01/05/2024 | 01/06/2024 |
| 3 | 15/05/2024 | |
| 4 | 03/06/2024 | |
| 5 | 01/08/2024 | 01/09/2024 |
| 6 | 01/07/2024 | 01/09/2024 |
| 7 | 01/08/2024 | 01/09/2024 |
| 8 | 01/09/2024 |
Thanks!
RichOB ,
Please refer the below DAX and output:
Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pande
8 Replies
- Kedar_Pande
Super User
RichOB , Could you please elaborate on your request in more detail?
RichOBHi Kedar_Pande sure,
Between the dates of 03/06/2024 and 01/09/2024 there have been 5 total instances being reported, 2 of which do not have an end date as the cell is blank. I'd like a measure that will show the count of instances where the Date Completed cell is empty specifically between the date range above. So in this circumstance, 2 out of the 5 have not been completed yet. I can then use that measure to show on a card the number 2 and also use it in other calculations. I hope that helps.
Thanks
- Kedar_Pande
RichOBHow will you determine the date range? Is it set, or would you like to include a slicer to choose the start and end dates for calculating the blank instances between those dates?
- suparnababu8
