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
Cool dude.
1. Have to create one Table for Master Table . Using Dax Code like the below image
2. Have to create Relationship between Date Master to Other your Two Tables (Table A , Table B) with Date key like the below image
a) Date Master "Date" to Table A "Date"
b) Date Master "Date" to Table B "Date"
3. Drag Date from Date Master, then Channel, Impresion , session at and all, like below
Let me know if any help