Skip to Main Content
Learn Power BI
book

Learn Power BI

by Greg Deckler
September 2019
Beginner to intermediate content levelBeginner to intermediate
362 pages
9h 22m
English
Packt Publishing
Content preview from Learn Power BI

Creating and understanding relationships

Now that we can clearly see our tables and columns, we can create relationships between our tables. Creating relationships between tables allows calculations and aggregations to work across tables so that multiple columns can be used from separate, related tables. 

For example, once the People table and the Hours table are related to one another, we can use the ID column from the People table and the TotalHoursBilled column from the Hours table. By doing this, TotalHoursBilled will aggregate correctly for each user ID in the People table.

To create this relationship between the People table and the Hours table, perform the following step: Click on the ID column in the People table and drag and drop ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learn Power BI - Second Edition

Learn Power BI - Second Edition

Greg Deckler

Publisher Resources

ISBN: 9781838644482Supplemental Content