Forum Discussion

newhopepdx's avatar
newhopepdx
Icon for Resolver I rankResolver I
3 years ago
Solved

Comparing donations from two paralell periods

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 ...
Need Help
  • martincurbelor's avatar
    martincurbelor
    3 years ago

    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.

newhopepdx's avatar
newhopepdx
Icon for Resolver I rankResolver I
3 years ago

Thanks!

Clearly overlooked the simple solution. Trying to make it too complicated.