Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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 CrossJoin
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 🙂
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 CrossJoin
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
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
49 | |
45 | |
38 | |
37 |