Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
8 years ago
Solved

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/que...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

  • OneWithQuestion's avatar
    OneWithQuestion
    Post Prodigy
    8 years ago

    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?