Forum Discussion
Mark_Everett
Oct 07, 2020Copper Contributor
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...
SergeiBaklan
Oct 09, 2020Diamond Contributor
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