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

[Shree_185]

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

[v-janeyg-msft]

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

[smpa01]

@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