cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

How to combine two tables?

Hi - 

 

I want to combine each of the values from table 1 

sophie23_0-1614050969528.png

 

with all of the dates available in table 2.

sophie23_1-1614050990170.png

can you help advise how to do so?

 

Thank you! Any help would be much appreciated 🙂 

1 ACCEPTED SOLUTION
Super User II
Super User II

You can create a new table in DAX using Cross Join that will give you desired results.

 

Table = CROSSJOIN(Country,'Date')

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Super User II
Super User II

You can create a new table in DAX using Cross Join that will give you desired results.

 

Table = CROSSJOIN(Country,'Date')

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

Hi FarhanAhmed - 

 

Thank you so much for this! It worked 🙂

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.