How to combine two tables?

[sophie23]

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 🙂 

[FarhanAhmed · Accepted solution]

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

Table = CROSSJOIN(Country,'Date')

[sophie23]

Hi FarhanAhmed - 

Thank you so much for this! It worked 🙂