Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

FIRSTNONBLANK not working as expected

Hi,  I have 2 tables  PURCHASE_ORDER_LINE DELIVERY_LINE Both the tables have 2 fields  PO_REF PLANNED_SHIP_DATE DELIVERY_LINE table has both the fields populated. PURCHASE_ORDER_LINE has...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Not very clear...Did you want to get the matched Date from DELIVERY_LINE table?

I tried to create a calculated column using the formula you provided, and I also use LOOKUPVALUE() function to do it.

 

Column =
LOOKUPVALUE (
    'DELIVERY_LINE'[PlANNED_SHIP_DATE],
    'DELIVERY_LINE'[PO_REF], 'PURCHASE_ORDER_LINE'[PO_REF]
)

 

 

Here is the pbix file.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

 

Best Regards,
Eyelyn Qin