Correcting specific data values from an imported corrections table

Hi, Anonymous 

Nithinr has provided a scheme to you. I have the following additions. Based on your description, I use the following sample data:

sheet1 table:

sheet2 table:

The relationships between the tables are as follows:

I did this by using the following DAX expression in measure:

correct type measure =
VAR _id =
    CALCULATE ( MAX ( Sheet1[Inventory Number] ) )
VAR _type =
    CALCULATE ( MAX ( 'Sheet1'[Fuel Type] ) )
VAR _id1 =
    CALCULATE ( MAX ( Sheet2[Inventory Number] ) )
VAR _type1 =
    CALCULATE ( MAX ( 'Sheet2'[Fuel Type] ) )
RETURN
    SWITCH ( TRUE (), _id = _id1, _type1, _id <> _id1, _type )

Use calculate to obtain the Inventory Number and Fuel Type of the current row. Use the switch to determine whether the Inventory Number exists in the correct table, if it exists, the Fuel Type is the value in the correct table, and if it does not exist, it is the value of the current table.

Here are the results:

If you want to do this with calculated columns, here's a workaround:

Column =
VAR _id = 'Sheet1'[Inventory Number]
VAR _type = 'Sheet1'[Fuel Type]
RETURN
    SWITCH (
        TRUE (),
        _id = RELATED ( Sheet2[Inventory Number] ), RELATED ( Sheet2[Fuel Type] ),
        _id <> RELATED ( Sheet2[Inventory Number] ), 'Sheet1'[Fuel Type]
    )

The DAX execution result of the calculated column is as follows:

I've provided the PBIX file for this time below, and it would be great if I could help you

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.