Forum Discussion
Solved
Merging Tables with no shared columns
I need to 'merge' 2 tables in BI, using DAX only to create a new table, containing every row from each of the 2 tables. Table 1 is a DAX Dates table, dynamically populated with the following: ...
Hi N_R_000 ，
You could use crossjoin:
Table 2 = CROSSJOIN('Table',SELECTCOLUMNS(Ref_Dates,"Date",Ref_Dates[Date]))Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Hi N_R_000 ，
You could use crossjoin:
Table 2 = CROSSJOIN('Table',SELECTCOLUMNS(Ref_Dates,"Date",Ref_Dates[Date]))
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien