Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
73
Views
Topic starter
See attached file
I have a row for each year of a contract. I need to create a table that includes only the final year of the contract data ie when it truly expires to enable the calculation to give Total Contracts expiring in a given year
How can I do this?
Posted : 14/01/2019 11:26 am
Hi,
Something like this?
Posted : 17/01/2019 2:10 am
Topic starter
Yes. Thanks. But I can't see how you have calculated it?
Posted : 19/01/2019 7:17 pm