cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
THENNA_41
Post Partisan
Post Partisan

blank value replace it from another column value

I have the two table Global Column and  local BOM. i have created  below measure to get ReferenceBom value. its return the correct vallue . I want replace  the blank value  in reference bom measure with TYPE OF CHECK column value. How to modify the below measure .please any one help me . 

 

 

Reference BOM-Local =
CALCULATE (
    FIRSTNONBLANK ( 'local BOMs'[Reference BOM], 0 ),
    FILTER (
        ALL ( 'local BOMs' ),
        'local BOMs'[item code] = 'global BOM '[item code]
    ))

 

 

 

 

global BOM:

 

  Item Code             Item Type (Product Variant BOM)                                     TYPE OF CHECK 

  FA009644.07                60.T634                                                                            NULL

 FA009644.07           FA009644.07-SHIPPINGCASE-CAS                                      CASE-70

  FA009644.07          FA009644.07-BUNDLEPAPER-OUT                                      PAPER-63

                                  

 

 

local BOMs :

 

Item Code                    ReferenceBOM                   

  FA009644.07                60.T634

 

 

Expected Output:

 

  Item Code             Item Type (Product Variant BOM)          ReferenceBom                           TYPE OF CHECK 

  FA009644.07                60.T634                                                 60.T634                                       NULL

 FA009644.07           FA009644.07-SHIPPINGCASE-CAS            CASE-70                                     CASE-70

  FA009644.07          FA009644.07-BUNDLEPAPER-OUT            PAPER-63                                    PAPER-63

1 ACCEPTED SOLUTION
sebouier
Frequent Visitor

Try this ?

 

ReferenceBom = IF(ISBLANK(TYPE OF CHECK), [Item Type], [TYPE OF CHECK])

 

View solution in original post

1 REPLY 1
sebouier
Frequent Visitor

Try this ?

 

ReferenceBom = IF(ISBLANK(TYPE OF CHECK), [Item Type], [TYPE OF CHECK])

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors