Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi friends:
I need to merge two table keeping same data. Please see the screen shot below for better understanding. Can any one help me to get my expeted result? Or share any link for solve my issue.
Expecting your kind cooperation.
Regards.
Silas Das Gupta.
Solved! Go to Solution.
@SilasDasGupta , seem like cross join
In Dax a new table
crossjoin(Table1, Table2)
or generate(Table1, Table2)
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
@SilasDasGupta , seem like cross join
In Dax a new table
crossjoin(Table1, Table2)
or generate(Table1, Table2)
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |