Forum Discussion
Incomplete/incorrect relations between two tables in Excel Power Pivot Data Model
Greetings Excel Community - this is my first posting here.. Seeking expertise in building a Power Pivot Table leveraging two different tables of data loaded into the data model using the latest subs...
With data model only you may add both tables to data model and create two measures:
Logged Hours:=SUM(Logged[Hrs])
and
Billed Hours:=CALCULATE (
SUM ( Billed[Hrs] ),
TREATAS (
VALUES ( Logged[RO #] ),
Billed[RO#]
)
)after that create PivotTable from data model as