Help With Formulas on Tables Related to Calendar Table

[matthew_hampton]

Hello - Still a novice when it comes to PowerBI and how to handle relationships and such.

I have four tables set up with the star schema using a caledar table as the center where Gross Adds, Address Attributes and DM Campaign Raw data are all related back to a date.

I am trying to do two things and cannot seem to figure them out - 

1. I want to calculate the difference between a date on table Gross Adds and table DAW Address Attributes using key ServiceAddressID

2. I want to see if an event in table Gross Adds occured between two dates in table DM Campaign Data using key ServiceAddressID

Any help is appreciated.

[v-shex-msft]

HI @matthew_hampton,

Your relationship seems useless, all tables use calendar date as the relationship to link each other.(one to many relationship)

I can't find the accurate record mapping, so it is impossible to get datediff between different tables through serviceAddressid.

Regards,

Xiaoxin sheng