Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge 2 column in Direct Query

I have 2 table tbl1 & tbl2. Both the table have "ProductID" & "ProductVersion" column. For making the relationship between both the tables, I need to link "ProductID" & "ProductVersion" columns in bo...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

     

    I have waited for the Feb release before making my point on this thread and now as the Feb release has arrived, I have tried my hands on it.

     

    It too contains the issue of concatenating columns using Direct Query Mode which I have reported to them and hope that this will be fixed in March release.

    http://community.powerbi.com/t5/Issues/concatenation-of-column-not-working-in-Direct-Query-with-vertica/idi-p/356279

     

    Though I know that merging columns in DB will work in PBI, I am not going to do it because I don't think that will be a good idea.

     

    Thanks for having discussion with me on this Thread. I enjoyed getting idead from you.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

I think that you DAX shoud be as follows.

Product_ID = tbl1[product_key] & " " & tbl1[product_version]


Do you use the latest version of Power BI Desktop? I make a test using the above similar DAX in DirectQuery mode in January update of Power BI Desktop, everything works well.


Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

I am using version 2.51 for my development purpose in which the provided DAX query is not working.

 

I have also tried Version 2.54 (January release) but I want to exclude that version for the discussion in thread because Direct Query in 2.54 version is not working with my DB i.e. Vertica.

 

Thanks!!!