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,

 

I may not be able to join on the tables as they are unrelated tables, is there a different way I could try it please?

 

It might be partially working but I get an error :

 

"A table of multiple values was supplied where a single value was expected"

 

- we do get duplicate values in the columns due to the nature of the data.

 

I was able to get it to work using a visual calculation on the table - I subtract one date column from another date column and get the difference between the 2 as a 3rd column, but when I try and create a graph, it takes across all 3 columns, but I only want 2 columns.

 

I'm not trying to be difficult, its just proving to be more difficult than I thought   ðŸ™‚