Forum Discussion
Calculating completion % based on expiry dates
I think I only find 3 ID for the first one.
you can try this
Measure = DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Expiry Date]>=date(year(today())+1,4,1))),DISTINCTCOUNT('Table'[Property_ID]))for the second one ,you can try to create a column,late num =var _next=minx(FILTER('Table','Table'[Property_ID]=EARLIER('Table'[Property_ID]) && 'Table'[Issue_Date]>EARLIER('Table'[Issue_Date])),'Table'[Issue_Date])return if (_next>'Table'[Expiry Date],1)pls see the attachment below
Pleae clarify better how we can link your examples to the table you attached
It is all a mistery to me
Thanks
1
Current active figures
Current properties requiring gas certificate = 7
Has a current in-date certificate (an issue date for the next financial year) = 4
% with current certificate = 57%
2
% of properties that obtain a gas certificate late (when the issue date of the new cert is later than the previous expiry date)
FY 22/23 = 1 property due. 1 late = 100% Late
FY 23/24 = 2 properties due. 1 late = 50% late
FY 24/25 = 4 properties due. 2 late = 50% late
FY 25/26 = the 1st calculation can take care of the current financial year % (I think)
Hi FBergamaschi If we take the year 24/25 for example.
1 Lakeshore Drive, due 12/08/2024
The next issue date was 12/08/2024, this means it was completed on time
2 Logan Square, due 07/07/2024
The next issue date was 10/07/2024, which was completed late as it was more than 1 day later than 07/07/2024
5 Giddings St, due 01/02/2025
Completed late as there is no next issue date
8 Winnemac Park, due 08/08/2024
The next issue date is 08/08/2024, completed on time
4 properties had gas safety checks due in 24/25
2 were late being completed = 50% of properties had late gas safety checks:
If there is more than 1 day between the expiry date and the next issue date for the same property, it is classed as being completed late.
I hope this helps, please let me know if I can give you any more info.
Thanks