Forum Discussion
lookupvalue vs direct query
Hello, I'm little confused, in a microsoft documentation and in many articules it's highlighted that lookupvalue function is not supported in direct query. However I was able to create calc column in a dataset like below
calc column = LOOKUPVALUE(table[VersionNm],table[Skey],table2[ControlSkey])
and use it in one of my reports.
Appreciate for any explanation. thx
