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

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

  • dramirezkon's avatar
    dramirezkon
    Frequent Visitor
    3 years ago

    That´s worked!!!

     

    Thks