Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Create table from 2 column and 2 table

Dear friends how can i create table that combine "Date" from table 1 and "Value" from table 2 and let "Date" duplicate its selfves each row by each "Value" Table1 Date 01-01-21 02-01-21 ...

Need Help

amitchandak
5 years ago
Anonymous , why only 2 dates are repeating. Noy 4.

Option in Dax is crossjoin

new tbale = Crossjoin(Table1, Table2)

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

or

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

amitchandak

Super User

5 years ago

Anonymous , why only 2 dates are repeating. Noy 4.

Option in Dax is crossjoin

new tbale = Crossjoin(Table1, Table2)

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Anonymous

Not applicable

5 years ago

amitchandak sorry for misleading, i just need to shown as example , but all i need to repeat all date

amitchandak
Super User
5 years ago
Anonymous , Try crossjoin, I given example in last update
- Anonymous
  Not applicable
  5 years ago
  amitchandak it cant , Table 1 are Dax table and table1 and table2 are not relationship
  - amitchandak
    Super User
    5 years ago
    Anonymous , crossjoin mean table with no relation
    
    refer: https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

Forum Discussion

Create table from 2 column and 2 table

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create columns group

Creating custom columns keeps returning a structured Table column