Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
03-01-21
04-01-21

 

Table2

A

B

C
D

 

What i expected

DateValue
01-01-21A
01-01-21B
01-01-21C
01-01-21D
02-01-21A
02-01-21B
02-01-21C
02-01-21D
03-01-21A
03-01-21B
03-01-21C
03-01-21D
04-01-21A
04-01-21B
04-01-21C
04-01-21D

 

thank you in advance for any suggestions

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@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

Anonymous
Not applicable

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

@Anonymous , Try crossjoin, I given example in last update

Anonymous
Not applicable

@amitchandak it cant , Table 1 are Dax table and table1 and table2 are not relationship

@Anonymous , crossjoin mean table with no relation

 

refer: https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.