Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello !
I am new using power bi so i am sorry if this is a basic question. Tried to search similar questions but couldnt find an answer.
I want to create a new table (Table 3. Result) combining data from two other tables (Table 1 and 2) in the following way:
Table 1:
ID | Description |
1 | A |
2 | B |
3 | C |
Table 2:
Attribute |
XX |
YY |
ZZ |
Table 3. Result
ID | Description | Attribute |
1 | A | XX |
1 | A | YY |
1 | A | ZZ |
2 | B | XX |
2 | B | YY |
2 | B | ZZ |
3 | C | XX |
3 | C | YY |
3 | C | ZZ |
Thanks ! 🙂
Juampi
Solved! Go to Solution.
@Juampi ,
crossjoin(Table1,Table2)
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
@Juampi ,
Create new table using below CrossJoin DAX:
New Table = CROSSJOIN(Tbl1,Tbl2)
Refer screen shot attached:
Thanks 🙂 it worked!
@Juampi ,
Create new table using below CrossJoin DAX:
New Table = CROSSJOIN(Tbl1,Tbl2)
Refer screen shot attached:
@Juampi ,
crossjoin(Table1,Table2)
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
User | Count |
---|---|
102 | |
84 | |
77 | |
70 | |
67 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |