PowerBI - Connecting Gift Table to Campaign Table

Hey @Ryan York, there's a couple ways to connect the Campaign table to the Gift Table.

First option it to expand the giftsplits column on the Gift table. That column is a list of records for each gift with all of the information related to Fund, Campaign, Appeal, etc. After that, load the Campaign table into your data model and connect on Campaign ID (second image). If you choose this option, you need to ensure you also expand the Amount field within in the gift_splits column and use that Amount field instead of the regular Amount field that comes in with the original table.

Second option (third image) is to bring in the Gift Splits table and connect your dimension tables to the Gift Splits table. You can connect the Gift and Gift Splits table, I wouldn't necessarily recommend it because of the 1:1 relationship of the tables. You'll get some wonky Filter Context issues in your DAX if you're not careful.

Hi @Matt Thacker,
Thanks for your response here. I'm tracking everything you're saying and it all makes sense to me. Where I get stuck is that when I expand the underlying info behind Gift_Splits, I create multiple rows per gift (if there was more than one appeal, fund, etc… for the gift) and that creates an error because Power BI expects each value in that column to be unique… How do I get around that?

@Matt Thacker, Thank you so much! I believe I'm up and running as well!

Hey @Mark Warner, in your Power Query editor for your Gifts table, you should see a column like this one:

Image is a bit blurry but that column is a column of Lists. You can expand that column and get select the columns from that List that you want to extract.