The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
Hi @RichOB ,
Please try creating calculated column,
End_Year = IF(NOT ISBLANK([End_Date]), YEAR([End_Date]))
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.
Hi @RichOB ,
Please try creating calculated column,
End_Year = IF(NOT ISBLANK([End_Date]), YEAR([End_Date]))
Hello, can you be more specific about what "input" means ? Do you mean by input "not null" ?