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!
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
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!