LOOKUPVALUE function isn't available when defining a calculated column

[Zemmel]

I'm trying to use the LOOKUPVALUE function for a calculated column, but when I go to the modeler and try to define the column, the LOOKUPVALUE function isn't available to use for some reason.  I've used this in other models countless times and not sure why it's not available to me with this new project.

The tables in my model are based on a Kusto query (using direct query), and not sure if that has something to do with it.

[Anonymous · Accepted solution]

Thank @ThxAlot 

Hi, @Zemmel 

You mentioned that creating calculated columns in directquery mode using the lookup value function is a limitation:

DirectQuery in Power BI - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

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

[ThxAlot]

Intellisense shows available functions only under current evaluation context.