I have two tables in Powerpivot for Excel 2013 that I would like to combine into one report.
The example in the attached file may explain what I require, however this is only sample data due to the original data being commercially sensitive.
My question refers to the calculation syntax that I need to achieve "Data to Encapsulate" within the "desired result" section. As there are many results (some duplicated) I cannot simply use =RELATED(Data to Encapsulate) as this throws an error.
This link Link
does seem to be similar to what I require, however it seems awfully complicated and, as I am looking up in another table, difficult to alter.
Thanks in advance.