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
Baskar
Resident Rockstar
Resident RockstarCan u please tell me what is the relationship between these two tables .
like date to date or Channel to channel ? like this