Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tecumseh
Resolver II
Resolver II

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

2 REPLIES 2
tecumseh
Resolver II
Resolver II

@Daniel29195 

 

Thanks,

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

Thanks,
w

Daniel29195
Super User
Super User

@tecumseh 

 

lookupvalue takes a column reference . 

 

Daniel29195_0-1706570976214.png

 

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! 🤠

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.