Avatar of martinibbo
martinibbo
 asked on

How do you return multiple results to one cell using powerpivot for excel?

Hi Experts,

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.
EE-Question.docx
Microsoft OfficeMicrosoft ExcelSQL

Avatar of undefined
Last Comment
Phillip Burton

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Phillip Burton

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
martinibbo

ASKER
OK thanks, I will try to amend to suit my needs then.

researching into RELATEDTABLE() it appears that I need another formula to prefix it such as =SUMX(RELATEDTABLE(),).

This will only work with values, if the data I want is text (Such as in my example), is there a way to return this, even if its on different rows? (i.e. one row per result and not concatenated as in my original question)

Sorry, I am very new to powerpivot!

Thanks
Phillip Burton

The PATH() function in the link you provided should work with RELATEDTABLE, as it works with columns. See https://msdn.microsoft.com/en-us/library/gg492167.aspx for information on PATH().
Your help has saved me hundreds of hours of internet surfing.
fblack61