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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
HEW
Helper III
Helper III

Create a new table from columns from existing tables

Hi.

 

I would like to create a new table based on 2 existing tables.

Table "Currencies" consists of one column "Fra" with the values: 

DKK

CAD

GBP

SEK

 

Table "Dates" consists of one column "Fulldate" with dates as follows (example):

01-01-2018

02-01-2018

03-01-2018

04-01-2018

05-01-2018

 

The new table should consist of both tables, so the data should be (in one column:

01-01-2018-DKK

01-01-2018-CAD

01-01-2018-GBP

01-01-2018-SEK

02-01-2018-DKK

02-01-2018-CAD

02-01-2018-GBP

02-01-2018-SEK

And so on....

 

How can I create such a table?

Thanks a lot in advance.

1 ACCEPTED SOLUTION
rohit01
Frequent Visitor

Hi Hew, 

 

you can acheive this by using following steps:

Create New table using CrossJoin  & then calculated column : use concatenate to acheive desired result, please refer to snapshot below:

Create Newtable using CrossJoinCreate Newtable using CrossJoinCreate Calculated  column shown as "Result" above and use concatenate ()Create Calculated column shown as "Result" above and use concatenate ()

I hope that helps 🙂

Please dont forget to accept it as solution if it works 🙂 

View solution in original post

4 REPLIES 4
rohit01
Frequent Visitor

Hi Hew, 

 

you can acheive this by using following steps:

Create New table using CrossJoin  & then calculated column : use concatenate to acheive desired result, please refer to snapshot below:

Create Newtable using CrossJoinCreate Newtable using CrossJoinCreate Calculated  column shown as "Result" above and use concatenate ()Create Calculated column shown as "Result" above and use concatenate ()

I hope that helps 🙂

Please dont forget to accept it as solution if it works 🙂 

It worked perfectly - thanks a lot.

Br. Helen

rohit01
Frequent Visitor

Hi Hew,
Could you please confirm if table "Currencies" and "Dates" are related , if yes, on what condition you want to concatenate two columns?

 

Thanks
Rohit

Hi Rohit.

 

The existing tables are not related.

 

Br.

Helen

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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