Create a summary table using power BI

Question

Hello,

Join multiple tables to create a summary table i.e picking one or two columns from 7 to 10 tables/spreadsheets to create a summary table.

Summary table will have one record per subject.

I am pretty good in Excel and want to advance my skills

Answer 1

Hi Nar,

You can create your relationships in Power BI and then use Slicers (recommended) or Filters to further define your data range.As long as you have determined a combination of non-duplicated Primary Keys and Related or Foreign Keys in each of your tables.