Forum Discussion
Join/Pivot Imported table with Calculated table.
I have 2 tables (as an example), the first table is imported in data and the 2 table is a calculated table.
How can I join and pivot the tables so the end result looks similar to this... so i have a "Region, Country and Carrier" line for each keyword.
Demo file: https://www.dropbox.com/s/c7e6ky1j9hl9x7l/Join%20Piviot%20Calculated%20Table.pbix?dl=0
Hi StuartSmith ,
Looks like you're trying to create a crossjoin.
Create a new table in the Data view using the following code:
crossJoin = CROSSJOIN(Sheet1, 'Key Words')This gives me the following output:
Pete
7 Replies
StuartSmith , Based on what I got. Crossjoin in DAX
crossjoin(Table1,Table2)
https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Check for any merge option in power query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi StuartSmith ,
Looks like you're trying to create a crossjoin.
Create a new table in the Data view using the following code:
crossJoin = CROSSJOIN(Sheet1, 'Key Words')This gives me the following output:
Pete
Thanks, one question, if either of the "Sheet1" or "Key Words" tables are updated, woould this updated be reflected in the "Join" table?
Just tested and yes it does 😁
