Forum Discussion
tzimmerman
3 years agoRegular Visitor
Help creating measure between two tables
I have 2 tables and I am looking to calculate the total calls and total time available, but my current formulas are not giving the correct totals I have Daily Agent Activity and Reservation Stati...
AnkitKukreja
3 years agoSuper User
Hi tzimmerman
You need to add a bridge table between Reservation Statistics and Daily Agent activity to create 1 to many relationship and then your model will be working like a star schema.
- tzimmerman3 years agoRegular Visitor
AS I am pretty new to power BI, how does one createa bridge table?
- AnkitKukreja3 years agoSuper User