Forum Discussion

kpangelinan's avatar
kpangelinan
Helper I
9 years ago
Solved

Lookup Value

I have two tables (1) Opportunity History Stage 1 and (2) Opportunity History All. In both tables there is an Opportunity.Id column which I can use to create a relationship. Also, In the Stage 1 tabl...
Need Help
  • prakash_gautam's avatar
    prakash_gautam
    9 years ago

    Hi,

     

    For a DAX solution you can use (if there is relationship and OpportunityHistoryAll is in many side):

     

    NewColumn = RELATED(OpportunityHistoryStage1[From Stage 1])

     

    without a relationhip:

     

    NewColumn = LOOKUPVALUE('OpportunityHistoryStage1'[From Stage 1],[Id],[Id])

     

    Plese see screen below.

     

    Thanks

prakash_gautam's avatar
prakash_gautam
Resolver II
9 years ago

Hi,

 

For a DAX solution you can use (if there is relationship and OpportunityHistoryAll is in many side):

 

NewColumn = RELATED(OpportunityHistoryStage1[From Stage 1])

 

without a relationhip:

 

NewColumn = LOOKUPVALUE('OpportunityHistoryStage1'[From Stage 1],[Id],[Id])

 

Plese see screen below.

 

Thanks

kpangelinan's avatar
kpangelinan
Helper I
9 years ago

prakash_gautam This worked perfectly. I used the lookupvalue option and was able to pull in the 'Yes' column.

Thank you so much for your time and help!