Dates based on two different FY

[UK_User123456]

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 calc that gives me the difference between the two dates, however the problem is if I put a FY filter in, it changes both the dates, whereas I need to have two filters so that the "Last Gift Donated" is filtered on FY18/19 and the second filter will filter "Last Gift Date" for FY 19/20, so that I can calculate the difference between the two. 

Is this possible?

TIA

[TomMartens]

Hey,

you can use Power Query to create one single table using the Merge action, this article https://radacad.com/append-vs-merge-in-power-bi-and-power-query describes this in greater detail.

Hopefully this is what you are looking for

Regards,

Tom

[UK_User123456]

Unfortunately, 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

[Iamnvt]

hi,

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 · Accepted solution]

You need 2 different calendar tables to have 2 filters separately.

you can check the PBI here:

https://1drv.ms/u/s!Aps8poidQa5zk6pZb6ArH1hA6Cu_uQ