Lookup value + if not isblank

[Anonymous]

Hi 

I have an error with this formula : 

column = IF(NOT(ISBLANK('RoadMapFollowUp as of mm-yyyy'[C Deliverable])), LOOKUPVALUE('Delivrable as of end mm-yyyy'[MD],'Delivrable as of end mm-yyyy'[Deliverable.Name],'RoadMapFollowUp as of mm-yyyy'[C Deliverable]))

here's the error : A table of multiple values was supplied where a single value was expected.

I need that the column retrieves data from the "MD" when the "c delivrable" is not empty.

Thanks

[v-eachen-msft]

Hi @Anonymous ,

Do you have only one "MD" for each non-blank "C Deliverable"?

[Anonymous]

Hi,

Yes exactly, each non blank C delivrable have one MD

But there is some c derivrable with the same name and have the same MD

[amitchandak]

Try like

IF(NOT(ISBLANK('RoadMapFollowUp as of mm-yyyy'[C Deliverable])), LOOKUPVALUE('Delivrable as of end mm-yyyy'[MD],'Delivrable as of end mm-yyyy'[Deliverable.Name],firstnonblank('RoadMapFollowUp as of mm-yyyy'[C Deliverable],blank())))

[Anonymous]

I tried it and i have the fllowing error : Too few arguments were passed to the LOOKUPVALUE function. The minimum argument count for the function is 3.

[Mariusz]

Hi @Anonymous 

1. What table are you adding the column to?
2.  What is the relationship between the tables?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Hi,

I'm adding the column to the table "RoadMap..."

The relationship is "many:many" between "delivrable.name" from the table delivrable and "delivrable c" from the table road map.