Forum Discussion
LOOKUPVALUE function isn't available when defining a calculated column
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.
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.
2 Replies
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
Super User
Intellisense shows available functions only under current evaluation context.
