Forum Discussion
Helper ICROSS JOIN TWO TABLES using MERGED QUERIES
Good Morning dear PBI Community,
is there any way to merge two queries using CROSS JOIN. The two tables (Country and Product) doesn't have any key Column to match.
It would be great to do it directly in PBI.
Thank You
En Power Query Editor:
In Table1 add Custom Column being the formula - Table2
In Table1 ExpandTableColumn
Get the CrossJoin
7 Replies
- amitchandak
Super User
medonication , yes CROSSJOIN itself
CROSSJOIN(Country ,Product)
refer https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Power Query -https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
medonicationDo you mean in Merge Queries ? Or how ?
- medonication
I found only following options
- amitchandak
medonication , In DAX, prefer crossjoin. For POwer Query refer https://exceleratorbi.com.au/cross-join-with-power-query/
- medonication
Thanks but I want to do that in as in the query editor
Payeras_BISolution Sage
En Power Query Editor:
In Table1 add Custom Column being the formula - Table2
In Table1 ExpandTableColumn
Get the CrossJoin
