select the specific column when apply crossjoin

[NickProp28]

Dear Comunity,

Here is the crossjoin code, but i do not want ConsolNumber appear two time in this table. I tried many time but still occured syntax error. I had refered this website (https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/) but I didnt get the solution.

Newtable = FILTER(CROSSJOIN(TEU,Summarize(Client, Client[ConsolNumber], Client[Unique Match Column] )),Client[ConsolNumber]= TEU[ConsolID]

ConsolNumber = Client[ConsolNumber]
Unique Match Column = Client[Unique Match Column]

Teu= TEU[TEU]

ETD= TEU[ETD]

Client[ConsolNumber]=TEU[ConsolNumber]
I knew there have append queries option in query editor, but since column unique match is a measure column. So I cant use this option. 

Kindly have a look on this pbix: https://ufile.io/lcuc78v5

[amitchandak · Accepted solution]

@NickProp28 , summarize on top of it

like

Newtable = SUMMARIZE(FILTER(CROSSJOIN(TEU,Summarize(Client, Client[ConsolNumber], Client[Unique Match Column] )),Client[ConsolNumber]= TEU[ConsolID]), [ConsolNumber],[Unique Match Column],[ETD],[TEU])

check if selectcolumns can help too