Day count if an end date is input

[RichOB]

Hi, using the table below, I want to split up 2023 and 2024 and have a Count based on how many end dates there are. I'm looking for:

2023 = 3
2024 = 5 

Start_Date	End_Date
01/06/2023	01/07/2023
01/07/2023	25/07/2023
01/08/2023
01/09/2023	12/09/2023
01/06/2024	01/07/2024
01/07/2024	01/08/2024
01/08/2024
01/09/2024	22/09/2024
01/10/2024	11/10/2024
01/11/2024	21/11/2024

Thanks

[ajaybabuinturi]

Hi @RichOB,
I'm not sure about out put results you are looking. However I am assuming you want to to count end dates based on year. you can follow the below steps.

1.Make sure year column is avaialble in the dataset (Create a calculated column based on enddate). I believe provided End_Date is not in proper Date format. Make sure all dates are in Date format.

EndDtYr = YEAR('Table'[End_Date])

2.Create a measure for count of end dates 

CountEnd_Date = COUNT('Table'[End_Date])

 3.Make sure when you are using EndDtYr column should be don't summarize.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

[BhavinVyas3003 · Accepted solution]

Hi @RichOB ,

Please try creating calculated column,

End_Year = IF(NOT ISBLANK([End_Date]), YEAR([End_Date]))

[freginier]

Hello, can you be more specific about what "input" means ? Do you mean by input "not null" ?