Search found 1 match
Search found 1 match • Page 1 of 1
- Mon Sep 20, 2021 3:27 pm
- Forum: Power Query
- Topic: Extract static data from data models in other Power Pivot workbooks
- Replies: 3
- Views: 549
You should be able to make a second table in the Data model that lists the People in one column and their respective group in the second column. Then go Data - Manage Data Model, and under 'Design' select 'Create Relationship' and create a relationship between the names list in the table you just cr...