Forum Discussion
Dates 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 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
You need 2 different calendar tables to have 2 filters separately.
you can check the PBI here:
5 Replies
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
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
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.
