Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replace a value with data from a different table if blank

Hello! I have a requirement to replace any blank values in a column with a different value.  While this can be done with an IF statement in the same table, the replacement value is in a different ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Figured it out!  Added this to a new column based on the test data: 

    Replace =
    IF('Table1'[Table 1 "names"] = "",
        (
            VAR Test1 = LOOKUPVALUE(Table2[Location 1 keys], Table2[Nameskey], Table1[Names keys])
            VAR Test2 = LOOKUPVALUE(Table3[Location 2 keys], Table3[Location 1 keys], Test1)
            VAR Test3 = LOOKUPVALUE(Table4[Table 4 "account"], Table4[Location 2 keys], Test2)
            Return Test3
        ),
        Table1[Table 1 "names"]
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Figured it out!  Added this to a new column based on the test data: 

Replace =
IF('Table1'[Table 1 "names"] = "",
    (
        VAR Test1 = LOOKUPVALUE(Table2[Location 1 keys], Table2[Nameskey], Table1[Names keys])
        VAR Test2 = LOOKUPVALUE(Table3[Location 2 keys], Table3[Location 1 keys], Test1)
        VAR Test3 = LOOKUPVALUE(Table4[Table 4 "account"], Table4[Location 2 keys], Test2)
        Return Test3
    ),
    Table1[Table 1 "names"]
)