Forum Discussion

Zemmel's avatar
Zemmel
New Member
2 years ago
Solved

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 u...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.