Forum Discussion

sebastian_ebg's avatar
sebastian_ebg
Helper I
9 years ago

Multi-table DAX Attribution Model

I'm trying to generate an attribution model for our company's emails based off a few different related tables. I'm fairly new to DAX, so I've been fumbling around a bit searching for examples of how ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi sebastian_ebg,

 

Can you share us a sample file to test? It is hard to know your table relationships from your screenshot.

 

Regards,

Xiaoxin Sheng

sebastian_ebg's avatar
sebastian_ebg
Helper I
9 years ago

Unfortunately it's very difficult for me to share a sample file as it contains sensitive data. I may spend a day anonymising and reducing the data so that I can share it because it still has me stumped.

 

In the mean time, this is the relationships of the tables:

 

LineItems[SKU]* - ProductDetails[SKU]1
LineItems[CustomerKey]* - CustomerDetails[CustomerKey]1
MailingDataFull[CustomerKey]* - CustomerDetails[CustomerKey]1

 

Hopefully this helps. If not, I will work on anonymising the data.