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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Let me try to make the issue little clearer

    The lookup field is PO_REF

    The table used as reference is DELIVERY_LINE, which does have the PLANNED_SHIP_DATE and the PO_REF fields populated. 

    Does this make the question clearer?