blank value replace it from another column value

Question

I have the two table Global Column and&nbsp;&nbsp;local BOM. i have created&nbsp; below measure to get ReferenceBom value. its return the correct vallue . I want replace&nbsp; the blank value&nbsp; in reference bom measure with&nbsp;TYPE OF CHECK column value. How to modify the below measure .please any one help me .&nbsp;&nbsp;&nbsp;Reference BOM-Local =CALCULATE (&nbsp; &nbsp; FIRSTNONBLANK ( 'local BOMs'[Reference BOM], 0 ),&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; ALL ( 'local BOMs' ),&nbsp; &nbsp; &nbsp; &nbsp; 'local BOMs'[item code] = 'global BOM '[item code]&nbsp; &nbsp; ))&nbsp;&nbsp;&nbsp;&nbsp;global BOM:&nbsp;&nbsp; Item Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Item Type (Product Variant BOM)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TYPE OF CHECK&nbsp;&nbsp; FA009644.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60.T634&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NULL&nbsp;FA009644.07&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA009644.07-SHIPPINGCASE-CAS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CASE-70&nbsp;&nbsp;FA009644.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA009644.07-BUNDLEPAPER-OUT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PAPER-63&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;local BOMs&nbsp;:&nbsp;Item Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReferenceBOM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; FA009644.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60.T634&nbsp;&nbsp;Expected Output:&nbsp;&nbsp; Item Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Item Type (Product Variant BOM)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReferenceBom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TYPE OF CHECK&nbsp;&nbsp; FA009644.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60.T634&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;60.T634&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL&nbsp;FA009644.07&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA009644.07-SHIPPINGCASE-CAS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CASE-70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CASE-70&nbsp;&nbsp;FA009644.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA009644.07-BUNDLEPAPER-OUT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PAPER-63&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PAPER-63

sebouier · Accepted Answer

Try this&nbsp;?&nbsp;ReferenceBom = IF(ISBLANK(TYPE OF CHECK), [Item Type], [TYPE OF CHECK])&nbsp;

Forum Discussion

blank value replace it from another column value

1 Reply

Related content

Replace null values of one column to another column.

Query editor replacing values based on another column

How to replace one column value with another column value from another table?

Replace null values with contents from another column

Replace value with value from another column?