Forum Discussion
Custom Column in direct query built and combined with values from another table.
them create a new dax table from the direct query table and that shooud let you add the column to that new table
Resident Rockstargo to the relantionship view, and selec the table in direct query, you should be able (as long isnst a direct query of a power bi service dataset) to set the direct query table mode to dual in the properties pane, this will allow to work the tablas a direct and import mode,
also if you set a relantionship between this 2 table you should be able to use the same effect on a dax for visuals without merging,
if this helped give some kudos and mark as solution for others to find
The table comes from a SQL service analysis so I think its from a dataset. In the properties pane I don't have the option of dual.
I have tried using a Vlookup however it doesnt work