Forum Discussion

agustinsuarez's avatar
agustinsuarez
Regular Visitor
9 years ago
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...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

agustinsuarez A date table linked to both of the example tables would allow you to just use your default columns without the need to create a calculation. Something simplistically that look like this.