Forum Discussion
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 ...
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,
it will come from a separate table called "FixTable" and here is the sample data inside it. Data in the "FixTable" are only those numbers with blank letters.
I tried using your code but it did not work. can you check what was wrong with it?
Result_Column =
IF (
ISBLANK ( [Column B] ),
LOOKUPVALUE (
'FixTable'[Letter],
'FixTable'[Number], [Column A]
),
[Column B]
)
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi 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,
hey it works! thanks v-jiascu-msft