Hi Power Users,
I have a excel formula that does what i need , but now to translate that to work in Power Bi has been a nightmare.
I tried to google for answers but no luck. Okay so hopefully my table and explenation will make sense. I have the fields (Id , Parent Id, Summary) , So the Id field wil always be unique, but the parent Id field can have multiple "numbers" that points to the Id field (see Id 3) , the summary field is description of Id and Parent Id (Where Id will be the Main info , and Parent Id the more detailed info. My question is I need to return the summary of the Id where the Parent Id matches the Id and not the summary value of the Parent Id "the more detailed part". My excel formula I use that works is - =INDEX(C:C,MATCH(B:B,A:A,0))
Thanks in advance
|Id||Parent Id||Summary||What I Need|
|4||3||C "and info of C"||C|
Solved! Go to Solution.
If I do that it doesnt want to accept the last column value.
ParentSummary = LOOKUPVALUE (Top30ParentSum[summary], Top30ParentSum[Id], Top30ParentSum[parent.id])
"A single value for column 'parent.id' in table Top30parentsum' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation......"
Not sure if this would help
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.