LOOKUPVALE fixed code

[dramirezkon]

HI!

Im trying to add a new columns on a calculate table using group by. But, when I trying to adding the new columns with LOOKUPVALUE Power BI dont make the search.

Any idea?

[v-yiruan-msft · Accepted solution]

Hi @dramirezkon ,

According to the error message, it seems that some titles may refer multiple Parent tasks, so please update the calculated column of the table "Tabla" as below:

Parent_Task =
CONCATENATEX (
    FILTER ( 'Work Items', 'Work Items'[Title] = EARLIER ( 'Tabla'[Title] ) ),
    'Work Items'[Parent],
    "; ",
    'Work Items'[Parent], ASC
)

Best Regards

[dramirezkon]

That´s worked!!!

Thks

[dramirezkon]

I tried it but was wrong to, the error was "The column 'Work Items'[Parent] doesnt exist

[VahidDM]

can you share your file if that does not have any sensetive data?

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[VahidDM]

Hi @dramirezkon

Are those two tables connected? Try to use the RELATED('Work Items'[Parent])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!