Forum Discussion
Post PartisanDay count if an end date is input
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
Hi RichOB ,
Please try creating calculated column,
End_Year = IF(NOT ISBLANK([End_Date]), YEAR([End_Date]))
3 Replies
- BhavinVyas3003
Super User
Hi RichOB ,
Please try creating calculated column,
End_Year = IF(NOT ISBLANK([End_Date]), YEAR([End_Date]))
freginierSolution Sage
Hello, can you be more specific about what "input" means ? Do you mean by input "not null" ?
- 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.
