Forum Discussion
How 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...
Hi,
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.
Ashish_Mathur - Emp columns cannot be joined as there is an existing join between Depts/Div. Sample pbix is avaialble in the post.
