dax function help
1 Topic
Create new table by combining 2 tables DAX (not in power query)
Hi, I have 2 tables (non relationship tables) I am trying to create 3rd separate table where i need to bring ALL available EMP IDs (TABLE 1) against each JOB NOs (table 2) having common CLUB IDs TABLE1 CLUB ID EMP ID ABC 123 ABC 456 ABC 789 AAA 001 TABLE2 CLUB ID JOB NO ABC XYZ ABC LMN ABC OPQ AAA XXX AAA YYY TABLE3 - Desired Table CLUB ID JOB NO EMP ID ABC XYZ 123 ABC XYZ 456 ABC XYZ 789 ABC LMN 123 ABC LMN 456 ABC LMN 789 ABC OPQ 123 ABC OPQ 456 ABC OPQ 789 AAA XXX 001 AAA YYY 001 Pls help, thanks in advanceSolved1.1KViews0likes5Comments