martingaleh
Board Regular
- Joined
- Jul 18, 2011
- Messages
- 83
I could never get pictures to save. Anyway,
I have a table (Table A):
https://pasteboard.co/HpTLfSL.png
and another table (Table B)
https://pasteboard.co/HpTLsxl.png
and I want to aggregate (Table B agg):
https://pasteboard.co/HpTLGFn.png
I can do this in power pivot. But then I want to join that back to the inital table and do math (resulting table)
https://pasteboard.co/HpTLR0x.png
Note here, this resulting table is joined by d2 and d3, which I don't show.
How do I make this. I image its' going to be an enormous nesting of calculates and sumx's.
I have a table (Table A):


and another table (Table B)
https://pasteboard.co/HpTLsxl.png

and I want to aggregate (Table B agg):
https://pasteboard.co/HpTLGFn.png
I can do this in power pivot. But then I want to join that back to the inital table and do math (resulting table)
https://pasteboard.co/HpTLR0x.png
Note here, this resulting table is joined by d2 and d3, which I don't show.
How do I make this. I image its' going to be an enormous nesting of calculates and sumx's.