Forum Discussion
Latest Date Financial Year
Hi Angith_Nair ,
According to your question, we have tried other methods, based on your actual data, I hope to help you with your question!
Our first step is to find the maximum date under each fiscal year, which we call MAXTable.Then we merger with the original table to get a MaxDate, which is the maximum date value for each fiscal year.
And finally, we add a new column to find out if each ID is the latest date.I hope this helps you solve your problem, if you have further questions you can check out the uploaded pbix, I'd be incredibly proud to solve your query!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks.
I tried this and I've ended up like this (this is the actual data):
I'd expect a 1 to be alongside 10000215136 and 1000025230 because they are the latest date for each financial year because they are the only entries, and for 1000025429 there should be a 1 against 21/002/2024 because that is the latest date in financial year 2023/2024 and a 1 against 19/06/2024 because it is the latest date in 2024/2025.
Hi Angith_Nair ,
According to your question, we have tried other methods, based on your actual data, I hope to help you with your question!
Our first step is to find the maximum date under each fiscal year, which we call MAXTable.
Then we merger with the original table to get a MaxDate, which is the maximum date value for each fiscal year.
And finally, we add a new column to find out if each ID is the latest date.
I hope this helps you solve your problem, if you have further questions you can check out the uploaded pbix, I'd be incredibly proud to solve your query!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
You are awesome!
Although this didn't quite do what I needed because it gave me the latest date rather than the latest financial date, I actually removed a financial year column from the dataset, so I used that instead of 'Year' for the grouping and it worked great.
Thanks!