Group by fields from 3 tables

Question

Hi&nbsp;In PowerBI Desktop, I need to group by data from 3 tables like&nbsp;&nbsp;Table1.ColumnA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table3.WeekNum1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table3.WeekNum2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table3.WeekNum3&nbsp; &nbsp;Table2.ColumnB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sum(Table2.ColumnC)&nbsp; &nbsp;Table2.ColumnB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sum(Table2.ColumnC)&nbsp; &nbsp; ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...Table1.ColumnA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table3.WeekNum1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table3.WeekNum2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table3.WeekNum3&nbsp; &nbsp;Table2.ColumnB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sum(Table2.ColumnC)&nbsp; &nbsp;Table2.ColumnB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(Table2.ColumnC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sum(Table2.ColumnC). ....&nbsp;Is it possible in Power BI ?&nbsp;What is the best way ?&nbsp;Thanks for your help

anonymous · Answer

Hi&nbsp;DRO&nbsp;&nbsp;Did you try this option in Query Editor.&nbsp;&nbsp;&nbsp;Thanks,Tejaswi

Forum Discussion

Group by fields from 3 tables

1 Reply

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Filter Field Parameter by Field Parameter Values without Calculated Groups

Table Visualization - Group By Field?

Community User Group Experience

Grouping in Tables