Forum Discussion

dramirezkon's avatar
dramirezkon
Frequent Visitor
3 years ago
Solved

LOOKUPVALE fixed code

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?

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • VahidDM's avatar
    VahidDM
    Super User
    3 years ago

    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!! 

     

  • dramirezkon's avatar
    dramirezkon
    Frequent Visitor
    3 years ago

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