Forum Discussion
select the specific column when apply crossjoin
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
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
1 Reply
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