Assume I have Table A with following structure: DateChannelDeviceSessions5/1/2016OrganicDesktop105/1/2016OrganicMobile55/1/2016OrganicTablet55/2/2016OrganicDesktop155/2/2016OrganicMobile105/2/2016OrganicTablet5 I also have Table B with following structure: DateChannelImpressions5/1/2016Organic1005/2/2016Organic200 My objective is to aggregate all the sessions from Table A into Table B, with the following output: DateChannelImpressionsSessions5/1/2016Organic100205/1/2016Organic20030 As I am still very new to Power BI, I give a similar SQL expression as I would do it using this language: SUM(Sessions) FROM Table A GROUP BY channel. Note that in the real data there are multiple different values for channel, and therefore I cannot just do a WHERE clause. Thanks!

Hi agustinsuarez, it could be, but your model is not ideal cause it's many-many. but there is workaround for your requirementCreate Dates table: Dates= Calendarauto()Create Channels table: Channels = values(TableA[Channel])Create 4 relationships with 3 actives as picture SS = sum(TableA[Session]) Details of relationships: If this works for you please accept it as solution and also like to give KUDOS.Best regardsTri Nguyen

Aggregate Values from Table A into Table B | Microsoft Fabric Community

Forum Discussion

Related content

Using Aggregate Tables and Partitions

Manage aggregations multiple fact tables DirectLake over OneLake

Aggregation in Matrix Table

Formatting Value of Table

Data Aggregation issue