Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problems with Merge Queries

Hello   I am using Merge Queries and I have the problems below:   1) The calculated columns do not appear in the list of columns to expand when I join a table, why is this happening? Can I not ex...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

     

    If you want to show blank and A in slicer, you need to create a new table. I create a sample. Please have a try.

    Table =
ADDCOLUMNS (
    VALUES ( Table2[Column1] ),
    "Table1_Column2", CALCULATE (
        MAX ( Table1[Column2] ),
        FILTER ( Table1, Table1[Column1] IN VALUES ( Table2[Column1] ) )
    )
)

     

     

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous merge query is a very expensive transformation. Regarding your first question, not sure what you mean by the calculated column, I assume, you have added a column in a table, and on merge, you are saying you cannot see this column. There is no reason why this column will not show up. It is very hard to say what you are doing and why this column is not showing, click load more on expand column dialog box, and see if you get to see all the columns?

 

Bottom line is, why you are doing the merge? Cannot you achieve the same using relationship in the model?