Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The project is driven by a database of donation history for several years. I'm wanting to compare total donations for two paralell 12-month periods in a matrix showing total donation by donor, count of donations and average donation for the period, and secondarliy display a table for both periods with the corresponding amounts and dates of donation.
I have a working solution, but it requires two slices set independantly. It uses a cloned, second "Comparison" date table (with a relationship to the main date table). The Comparison Date table is linked to the Period 1 "between" slicer.
What I'm looking for is a way to dispense with the Period 1 slicer and filter the data for the comparison period to be one year prior to the dates set in a single range date slicer (Period 2, in the current case). Is this possible?
Period 1 data is driven by the Comparison Date table and this measure:
Solved! Go to Solution.
Sould it works to create a Measure for the period 2?
Like:
CALCULATE(
[Donations],
SAMEPERIODLASTYEAR(Calendar, [Date])
)
There you will have both KPIs with just one slicer selected.
Thanks!
Clearly overlooked the simple solution. Trying to make it too complicated.
Sould it works to create a Measure for the period 2?
Like:
CALCULATE(
[Donations],
SAMEPERIODLASTYEAR(Calendar, [Date])
)
There you will have both KPIs with just one slicer selected.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |