Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
2 years ago

Lookupvalue In Var from another Var in 1 Calculated Table

Hi all,

Using up-to-date PBID.
Can I use LOOKUPVALUE to lookup a value from a Var from a different Var in the smae Calculated Table?

I dont see the VAR or Fieldnane as an option of LOOKUPVALUE, but thought I would confirm here.

Thanks,
w

Need Help

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    tecumseh 

     

    lookupvalue takes a column reference . 

     

     

    https://dax.guide/lookupvalue/

     

     

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

  • tecumseh's avatar
    tecumseh
    Resolver III
    2 years ago

    Daniel29195 

     

    Thanks,

    We have Tables and Columns inside each unique VAR inside the Calculated Table.
    Maybe VAR __T20 cannot "see" VAR __T10?

    Thanks,
    w