• Brian Carlson - Tuesday, October 17, 2017 10:32 AM

    Yes to the donation amount question.

    EventDate is the date dimension. I changed the name to be clear, since you can have more than one date dimension.

    That seems to have done the trick!

    Donation Amount PY:=
    SUMX (
    VALUES ('Event'[Event Year]),
    CALCULATE (
    [Donation Amount],
    ALL ( 'Date'),
    FILTER (
    ALL ( 'Event'[Event Year] ),
    VALUE('Event'[Event Year] )
    = EARLIER ( 'Event'[Event Year]) -1
    )
    )
    )

    I can't say I totally understand what it's doing, I have some reading to do 🙂

    Thanks for your help, much appreciated.