Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 .
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
Solved! Go to Solution.
Try this ?
ReferenceBom = IF(ISBLANK(TYPE OF CHECK), [Item Type], [TYPE OF CHECK])
Try this ?
ReferenceBom = IF(ISBLANK(TYPE OF CHECK), [Item Type], [TYPE OF CHECK])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.