Forum Discussion

Shree_185's avatar
Shree_185
Helper I
4 years ago

DIRECT query - LOOKUPVALUE function does not support / Looking for alternative function

I am using Direct query and want to use the LOOKUPVLAUE function, which does not support it. What could be the alternative for Loockupvalue in direct query

Need Help

2 Replies

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    Shree_185  you can't create a calculated column in DQ, so you need to create measures or you can have the column created on the RDBMS side if possible

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, Shree_185 

     

    Many similar functions cannot be used in DQ mode. If you can share some sample data and your desired result, we can see if there is a workaround.

     

    Best Regards,
    Community Support Team _ Janey