Forum Discussion

matthew_hampton's avatar
matthew_hampton
Helper I
8 years ago

Help With Formulas on Tables Related to Calendar Table

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.

 

 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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