Forum Discussion
UK_User123456
Resolver I
Resolver IDates based on two different FY
Hi All, I have 2 table(s) that has two different dates that I want to combine into 1 table (picture below), the first is "Last Gift Donated" and the second is "Last Gift Date". I have done a cal...
You need 2 different calendar tables to have 2 filters separately.
you can check the PBI here:
UK_User123456Resolver I
Resolver IHi,
I did try the "Sameperiodlast year" function, but it works but not in the way I need it to, I have put a sample dataset. What I need it to be able to use are two filter(s), the first to filter the last gift donation and the second to filter out last gift date, so that it controls different FY's.
e.g.
Last gift donation will show FY 18/19 and last gift date will show FY19/20
| Donor ID | Last Gift Donation | Last Gift Date |
| 1 | 01/01/2018 | 15/07/2019 |
| 2 | 02/02/2001 | 01/04/2001 |
| 3 | 01/01/2019 | 25/04/2019 |
| 4 | 23/05/2019 | 15/07/2019 |
| 5 | 15/03/2018 | 16/05/2018 |
| 6 | 17/06/2018 | 18/05/2019 |
| 7 | 12/09/2018 | 01/06/2019 |
Iamnvt
Continued Contributor
Continued ContributorYou need 2 different calendar tables to have 2 filters separately.
you can check the PBI here: