LOOKUPVALUE in Direct Query Calculated Column

Hi guys,

Are we able to use LOOKUPVALUE in CalculatedColumn in Direct Query ?
The main issue I have right now is I have a master table which I cannot put relation to it, but one of my Fact Table need addition info which I can get from that master table.

And what is the workaround if cannot.

Thanks in advance,
Toni

Hi @Toni

Please check https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about to find limitation of Direct Query.

One Limitations in calculated columns: Calculated columns are limited to being intra-row. So, Adding Column using Lookup from other table is not available.

For your case you can either use a join b/w tables in Source Query during extraction or use Merge inside Power Query to fetch required value from Master Table.

Regards,
Ankit Jain

1 Like

Hi @Toni, we’ve noticed that no response has been received from you since December 04, 2019. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. You may reopen a new thread when the need arises. Thanks!

1 Like