Need help with a date measure please

[RichOB]

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!

[suparnababu8]

Hi @RichOB 

Can you share pbix file with dummy data along with your input and expected output?

[Kedar_Pande]

@RichOB , Could you please elaborate on your request in more detail? 

[RichOB]

Hi @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?

[RichOB]

@Kedar_Pande yeah the date range is already set, no need for the slicer.

Thanks

[Kedar_Pande · Accepted solution]

@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

[RichOB]

@suparnababu8 Just for more context, I have a measure that gives me the total of 5 between that date range, I just need to add something to this to only bring back the total of the Date Completed where the cell is blank:

Reported = (

    CALCULATE(

        Count('Sheet1'[Customer Number]),

        'Sheet1'[Date Reported]>=DATE(2024,6,3),

        'Sheet1'[Date Reported]<=Date(2024,9,1)

    ))

Thanks

[Ashish_Mathur]

Hi,

Does this measure work?

Reported = CALCULATE(Count('Sheet1'[Customer Number]),'Sheet1'[Date Reported]>=DATE(2024,6,3),'Sheet1'[Date Reported]<=Date(2024,9,1),'Sheet1'[Date Reported]=blank())