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

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

agustinsuarez

If table A and table B are in a many to one relationship via the columns date and channel, you can create a new column, say joinkey in each table and create relationship against that new column.

In table A
joinKey = TableA[Date]&","&TableA[Channel]

In table B
JoinKey = TableB[Date]&","&TableB[Channel]

 

Check more details in the attached pbix.zip