The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Thanks,
We have Tables and Columns inside each unique VAR inside the Calculated Table.
Maybe VAR __T20 cannot "see" VAR __T10?
Thanks,
w
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! 🤠