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.
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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!