Forum Discussion
Solved
Aggregate Values from Table A into Table B
Assume I have Table A with following structure: Date Channel Device Sessions 5/1/2016 Organic Desktop 10 5/1/2016 Organic Mobile 5 5/1/2016 Organic Tablet 5 5/2/2016 O...
Hi agustinsuarez,
it could be, but your model is not ideal cause it's many-many. but there is workaround for your requirement
- Create 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 regards
Tri Nguyen
Hi agustinsuarez,
it could be, but your model is not ideal cause it's many-many. but there is workaround for your requirement
- Create 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 regards
Tri Nguyen
This can very easily be done in the query editor: In TableB you merge with TabeA on date and chanel (leave default join-type LeftOuter). Then when you expand the newly created column, you switch to "Aggregate" an choose "Sum" of Sessions.