replace null values with content from another column based on condition

I have 20 million rows loaded. I want to replace null values from Column B. The value to be replaced will depends on what value is indicated on the column a. Example: For null values, 1 = W ...

Need Help

Tips and Tricks

Tutorial Requests

v-jiascu-msft

7 years ago

Hi Anonymous,

Did you get any error messages? Or it returns wrong results?

Maybe this one.

Result_Column =
IF (
    [Column B] = blank(),
    LOOKUPVALUE (
        'FixTable'[Letter],
        'FixTable'[Number], [Column A]
    ),
    [Column B]
)

Best Regards,

Forum Discussion

replace null values with content from another column based on condition

Related content

Conditional Replace Using Outside table

Replace value based on condition from other column

Table Replace Value multiple condition

Replace value in Power Query based on condition

Replace null values with contents from another column