Direct Query and DAX COMBINEVALUES - how to set this up?

[OneWithQuestion]

I am a bit confused by this.

It said when you use direct query it will optimize the TSQL generated if you add a calculated column in PowerBI on the table?

https://msdn.microsoft.com/en-us/query-bi/dax/combinevalues-function-dax

So , if I have a Table that needs to join on multiple columns /composite key (instead of one single column key) then using COMBINEVALUES will help PBI optimize the TSQL it generates when doing a join?

How do you do that if you are using Direct Query with OUT importing the data?

Where do you add this calculated column at?

If we have data like this:  EventRoomSchedule table contains

Then have another table [EventSpeakersTimeAssigned] that shows the Even Speaker (speaker's name) and then Room# and Time to join them back to that table.

How do you handle that in DAX with COMBINEVALUES?

If I have a direct query (not import) I selected those tables in my data model... then what?

[v-jiascu-msft · Accepted solution]

Hi @OneWithQuestion,

Just add a new column and establish the relationship. Do you any special requirements?

Best Regards,

Dale

[OneWithQuestion]

OH!

Well I feel foolish!

In my mind I thought it was not possible to just add a calculated DAX column to a table like that when using direct query.

That makes sense though, so the query engine will see that DAX column and use it accordingly when it you make queries against the tables?