Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Create a new table with columns from 2 separate tables using DAX

Hi   Ive been trying to work out how to create a new table with 2 columns  - column A from table 1 , column B from table 2.    I want to create a custom table that just has the values I need, and...
DAX Command
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    would it please be possible to show the steps to make a copy of the tables inside powerbi , and then add indexes to those temp tables please and then use them?

    If you have a column in your table that can be sorted, you can use "Rankx" to create a calculated column. This is the main method of creating an index column using dax.

    RANKX function (DAX) - DAX | Microsoft Learn

    read-only data warehouse

    Do you mean warehouse in Fabric? What is your current connection mode? Change the connection mode to "import" to create index columns in Power Query. "Import" mode will create a copy of the data, and read-only mode has no effect.

     

    Best Regards,
    Wenbin Zhou

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi all,thanks for your quick response, I'll add more.

Hi Anonymous ,

You mentioned that there is no associated column between the two tables. And you need to join the two tables horizontally. It may not be possible to achieve your needs through DAX. I think you need to use Power Query to create an index column for the two tables and then perform the merge operation based on the index column.

 

Best regards

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi v-zhouwen,

 

As the tables are part of our existing read-only data warehouse, I may not be able to add the indexes to them.

 

So, would it please be possible to show the steps to make a copy of the tables inside powerbi , and then add indexes to those temp tables please and then use them? That would be incredibly helpful.   I have a SQL DBA background so understand things from a SQL Server & temp tables persepctive.

 

Ive been kind of dumped in the deep end with powerbi, its a steep learning curve.

 

Thank you for your help so far. ðŸ˜Š

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

    would it please be possible to show the steps to make a copy of the tables inside powerbi , and then add indexes to those temp tables please and then use them?

    If you have a column in your table that can be sorted, you can use "Rankx" to create a calculated column. This is the main method of creating an index column using dax.

    RANKX function (DAX) - DAX | Microsoft Learn

    read-only data warehouse

    Do you mean warehouse in Fabric? What is your current connection mode? Change the connection mode to "import" to create index columns in Power Query. "Import" mode will create a copy of the data, and read-only mode has no effect.

     

    Best Regards,
    Wenbin Zhou