Forum Discussion
Event Year YoY Comparison
Anonymous
I handle YoY comparisons within the eCom world, and imagine you can handle "Events" similiar to how I handle "Accounts" when reviewing performaces YoY.
Ensure you're categorizing your records by "Event" - and Name the Events accordingly.
Data Example -
Record 1 [Date, Event(A), Donation Made, CriteriaX, CriteriaY, CriteriaZ]
Record 2 [Date, Event(B), Donation Made, CriteriaX, CriteriaY, CriteriaZ]
Record 3 [Date, Event(A), Donation Made, CriteriaX, CriteriaY, CriteriaZ]
ect..
As long as you have a field specifying the Date, Event Name, and Donations($) - Then you can create the following measures:
Total Donations =
SUM ( [Donations] )Total Donations LY =
CALCULATE ( [Total Donations], DATEADD ( DATETABLE[DATES], -1, YEAR )
These two measures will allow you to review Total Donations (Overall, or with Sliced/Filtered Data), and the Total Donations LY for the same data.
Create a report containing a Slicer by Year, and a Table with the values of Events, Total Donations, and Dontations LY.
Let me know if this helps, enjoy!
- Anonymous6 years agoNot applicable
Thanks AlexAlberga727 , appreciate the feedback!