Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
6 years ago

LOOKUPVALUE in CalculateColumn in Direct Query

Hi guys,

 

Is it possible to use LOOKUPVALUE in CalculatedColumn in Direct Query ? 

Does someone has a good reference on this case ? 

 

Thanks,

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi admin_xlsior ,

     

    It is not supported to use LOOKUPVALUE in Calculated column in Direct Query. Please use Measure instead of Calculated column if you want to use LOOKUPVALUE in Direct Query.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.