Forum Discussion
POSPOS
Post Partisan
Post PartisanHow to create a summary table with dynamic fields
Hi All, I have three tables (Master, Source 1, Source 2). Based on the tables, my requriement is to create a summary table: Sample file -Download Master Table: Dept Sales Emp ID Div Dep...
Ashish_Mathur
Super User
Super UserHi,
Create a Many to One relationship from the Emp columns of the 2 source tables to the Emp column of the Master table. Create a 4th table with unique values of all Dept's. Create a Many to One relationship from the Dept column of the Master table to this 4th table. To your visual, drag Emp from the Master table and Dept from the 4th table.
POSPOSPost Partisan
Post PartisanAshish_Mathur - Emp columns cannot be joined as there is an existing join between Depts/Div. Sample pbix is avaialble in the post.