topic Re: LOOKUPVALE fixed code in DAX Commands and Tips

LOOKUPVALE fixed code

dramirezkon — Mon, 19 Sep 2022 22:36:17 GMT

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?

Re: LOOKUPVALE fixed code

VahidDM — Mon, 19 Sep 2022 23:14:10 GMT

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

Re: LOOKUPVALE fixed code

dramirezkon — Mon, 19 Sep 2022 23:41:47 GMT

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

Re: LOOKUPVALE fixed code

VahidDM — Tue, 20 Sep 2022 00:26:51 GMT

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

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: LOOKUPVALE fixed code

Anonymous — Tue, 20 Sep 2022 08:16:05 GMT

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

Re: LOOKUPVALE fixed code

dramirezkon — Thu, 29 Sep 2022 18:28:46 GMT

That´s worked!!!

Thks