Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |