Lookupvalue Columns in DirectQuery - How to relate DirectQuery data

[DCrowther]

Hi

I am new to DirectQuery data, and i am trying to create additional columns that relate and pull through related data from other tables for the visuals. I know that the normal LOOKUPVALUE only works in DirectQuery by creating a MEASURE then performing the LOOKUPVALUE formula within the measure.

The problem i have is that LOOKUPVALUE using Measures only seems to then pull back other data from other Measures in the related table, so if none of my related columns are measures, I cannot relate the data or create additional lookupvalue columns  ??

Am i supposed to some how turn existing test or numerical columns into Measures? if so can you help how i do this?

Regards

Dan

[v-chuncz-msft · Accepted solution]

@DCrowther ,

You may try adding SELECTEDVALUE.

• https://community.powerbi.com/t5/Desktop/Help-Combining-Query-with-Excel/m-p/450152#M208398
• https://community.powerbi.com/t5/Desktop/Percentage-to-goal-by-dynamic-date-range/m-p/642778#M307965