Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Default values with lookup function

I have two table 1. Dynamic(will update realtime) 2) static reference file  and used lookupvalue function to retrive value of one column from static rerence file to dynamic(new column). But, is there...
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    According to your description,I created 2 sample tables as below:

    Then create a calculated column as below:

    Column = LOOKUPVALUE(Table1[Value],'Table1'[Category],'Table2'[Category],Table2[Value])

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for reply. but my requirement bit different here

Some ex

Table-a col-1 col-2 Table-b col-1 ,col-3

currently I used table-a(col2) = lookupvalues(table-b(col3), table-b(col-1),table-a(col-1)) whis return value if table-a[col1] = table-b(col1), if not match i need pouplate table-a(col-2) = table-a(col-1). Hope its clear

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Do any of these work?

    =lookupvalues(table-b(col3), table-b(col-1),table-a(col-1),table-a(col-1))

    or

    =if(isblank(lookupvalues(table-b(col3), table-b(col-1),table-a(col-1))),table-a(col-1),lookupvalues(table-b(col3), table-b(col-1),table-a(col-1)))

    Hope this helps.