Forum Discussion

sophie23's avatar
sophie23
Frequent Visitor
5 years ago
Solved

How to combine two tables?

Hi - 

 

I want to combine each of the values from table 1 

 

with all of the dates available in table 2.

can you help advise how to do so?

 

Thank you! Any help would be much appreciated 🙂 

Power Query
Table
  • FarhanAhmed's avatar
    FarhanAhmed
    5 years ago

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

     

    Table = CROSSJOIN(Country,'Date')

     

     

2 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    5 years ago

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

     

    Table = CROSSJOIN(Country,'Date')

     

     

    • sophie23's avatar
      sophie23
      Frequent Visitor
      5 years ago

      Hi FarhanAhmed - 

       

      Thank you so much for this! It worked 🙂