Forum Discussion
Resolver IDates based on two different FY
You need 2 different calendar tables to have 2 filters separately.
you can check the PBI here:
Resolver IUnfortunately, I cant append or merge through power query as the dates are measures, so they dont appear in the power query editor, is there any other way?
Thanks
Continued Contributorhi,
looks like you want to modify the outer filter of your "last gift donation" measure to be previous year, and keep "last gift date" as the current selection in the filter. So you can try this measure:
new last gift donation = Calculate([last gift donation], SAMEPERIODLASTYEAR (Calendar[Date]))
so when you filter FY 19/20, this measure will give you the "last gift donation" of FY 18/19.
if still not ok, then please give a sample dataset.
- UK_User123456
Hi,
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
You need 2 different calendar tables to have 2 filters separately.
you can check the PBI here: