cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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

 

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

comp123.png

 

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?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

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

Hi @OneWithQuestion,

 

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

Direct_Query_and_DAX_COMBINEVALUES_how_to_set_this_up

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

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

Hi @OneWithQuestion,

 

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

Direct_Query_and_DAX_COMBINEVALUES_how_to_set_this_up

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

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

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?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors