Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
You need 2 different calendar tables to have 2 filters separately.
you can check the PBI here:
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.
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 |
You need 2 different calendar tables to have 2 filters separately.
you can check the PBI here:
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |