Forum Discussion
Measure for a table
PPL table sample data:
Registry | FY | StartDate | EndDate |
7 | 2022 | 28/06/2022 | 30/06/2023 |
7 | 2021 | 09/07/2021 | 30/06/2022 |
12 | 2023 | 10/11/2023 | 31/10/2024 |
12 | 2022 | 08/11/2022 | 31/10/2023 |
24 | 2020 | 28/08/2020 | 02/08/2021 |
24 | 2019 | 21/01/2020 | 31/07/2020 |
24 | 2018 | 15/11/2018 | 31/07/2019 |
33 | 2013 | 02/10/2013 | 30/09/2014 |
33 | 2012 | 24/09/2012 | 30/09/2013 |
33 | 2010 | 04/10/2010 | 30/09/2011 |
39 | 2021 | 16/08/2021 | 31/08/2022 |
39 | 2020 | 05/08/2020 | 31/08/2021 |
112325 | 2023 | 04/08/2023 | 02/09/2024 |
112325 | 2022 | 01/08/2022 | 31/08/2023 |
112325 | 2021 | 16/08/2021 | 31/08/2022 |
112325 | 2020 | 05/08/2020 | 31/08/2021 |
112325 | 2019 | 13/08/2019 | 30/08/2020 |
112325 | 2018 | 10/08/2018 | 02/09/2019 |
112325 | 2017 | 22/08/2017 | 31/08/2018 |
4288 | 2021 | 01/11/2021 | 01/08/2022 |
4288 | 2020 | 28/04/2021 | 02/08/2021 |
4288 | 2019 | 13/11/2019 | 31/07/2020 |
4288 | 2018 | 15/11/2018 | 31/07/2019 |
139348 | 2023 | 04/08/2023 | 02/09/2024 |
139348 | 2022 | 01/08/2022 | 31/08/2023 |
141765 | 2023 | 04/08/2023 | 02/09/2024 |
141765 | 2022 | 01/08/2022 | 31/08/2023 |
141765 | 2021 | 16/08/2021 | 31/08/2022 |
14065 | 2021 | 01/11/2021 | 01/08/2022 |
14065 | 2020 | 28/08/2020 | 02/08/2021 |
14065 | 2019 | 25/11/2019 | 31/07/2020 |
14065 | 2013 | 18/06/2013 | 31/12/2013 |
111578 | 2023 | 16/11/2023 | 31/07/2024 |
111578 | 2021 | 01/11/2021 | 01/08/2022 |
111578 | 2021 | 20/08/2021 | 31/08/2022 |
37 | 2023 | 27/06/2023 | 30/09/2024 |
37 | 2022 | 30/09/2022 | 02/10/2023 |
37 | 2021 | 27/09/2021 | 30/09/2022 |
42 | 2023 | 09/08/2023 | 13/03/2024 |
42 | 2022 | 19/01/2023 | 13/08/2023 |
95650 | 2023 | 26/06/2023 | 30/09/2024 |
95650 | 2022 | 07/07/2022 | 31/08/2023 |
95650 | 2020 | 31/08/2020 | 31/08/2021 |
14397 | 2023 | 27/06/2023 | 30/09/2024 |
14397 | 2023 | 07/06/2023 | 31/07/2024 |
14397 | 2023 | 03/05/2023 | 30/04/2024 |
130546 | 2023 | 27/09/2023 | 30/09/2024 |
130546 | 2022 | 29/09/2022 | 02/10/2023 |
130546 | 2021 | 30/09/2021 | 30/09/2022 |
130745 | 2023 | 27/09/2023 | 30/09/2024 |
130745 | 2022 | 29/09/2022 | 02/10/2023 |
130745 | 2021 | 30/09/2021 | 30/09/2022 |
141008 | 2023 | 27/09/2023 | 30/09/2024 |
141008 | 2022 | 29/09/2022 | 02/10/2023 |
170647 | 2023 | 27/09/2023 | 30/09/2024 |
170647 | 2022 | 29/09/2022 | 02/10/2023 |
170647 | 2021 | 30/09/2021 | 30/09/2022 |
185671 | 2023 | 27/09/2023 | 30/09/2024 |
185671 | 2022 | 29/09/2022 | 02/10/2023 |
185671 | 2021 | 30/09/2021 | 30/09/2022 |
187846 | 2023 | 27/09/2023 | 30/09/2024 |
187846 | 2022 | 29/09/2022 | 02/10/2023 |
198347 | 2023 | 16/06/2023 | 01/07/2024 |
198347 | 2022 | 22/06/2022 | 30/06/2023 |
200876 | 2023 | 16/06/2023 | 01/07/2024 |
200876 | 2022 | 22/06/2022 | 30/06/2023 |
206712 | 2023 | 16/06/2023 | 01/07/2024 |
206712 | 2022 | 22/06/2022 | 30/06/2023 |
202873 | 2023 | 16/06/2023 | 01/07/2024 |
200604 | 2023 | 16/06/2023 | 01/07/2024 |
200604 | 2022 | 22/06/2022 | 30/06/2023 |
200604 | 2021 | 11/03/2022 | 30/06/2022 |
129471 | 2023 | 15/06/2023 | 01/07/2024 |
129471 | 2022 | 01/06/2022 | 30/06/2023 |
129471 | 2021 | 10/11/2021 | 30/06/2022 |
161397 | 2023 | 15/06/2023 | 01/07/2024 |
161397 | 2022 | 01/06/2022 | 30/06/2023 |
161397 | 2021 | 10/11/2021 | 30/06/2022 |
163973 | 2023 | 15/06/2023 | 01/07/2024 |
163973 | 2022 | 01/06/2022 | 30/06/2023 |
163973 | 2021 | 10/11/2021 | 30/06/2022 |
168471 | 2023 | 15/06/2023 | 01/07/2024 |
168471 | 2022 | 01/06/2022 | 30/06/2023 |
172496 | 2023 | 15/06/2023 | 01/07/2024 |
172496 | 2022 | 01/06/2022 | 30/06/2023 |
172496 | 2021 | 10/11/2021 | 30/06/2022 |
176429 | 2023 | 15/06/2023 | 01/07/2024 |
176429 | 2022 | 01/06/2022 | 30/06/2023 |
176429 | 2021 | 10/11/2021 | 30/06/2022 |
176429 | 2020 | 17/11/2020 | 30/06/2021 |