Power Bi - gift amount, gift split amount

Christine Adams
Christine Adams
Tenth Anniversary Kudos 1 Name Dropper Facilitator 1
in SKY Developer General Discussions

Just started using Power Bi and trying to get a list of donors with their gift totals to certain funds so I would assume I would use gift split amount but in the table it is double counting - is this because I need to the gift.splits.fund.id to the fund.id in the fund table. I thought I did this by connecting the gift ids?

Tagged:

Comments

  • Christine Adams
    Christine Adams
    Tenth Anniversary Kudos 1 Name Dropper Facilitator 1

    Wanted to add - it appears that it totals up the fundraiser credit for each even though I'm not using a fundraiser filter. So if someone gave $200 and they have 3 fundraisers connected to the gift the gift.split total is showing as $600. The Fund.id and campaign.id are both connected to their appropriate fund and campaign IDs on those tables.

Categories