Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combining 2 tables and Summarize

Hello Everyone,

 

Good day.

 

Hoping to get some ideas and help how to achieve my requirements.

I have create 2 separate summarize table named 'Country' and 'Weekly Reporting'.

Basically, 'Country' table is summarize from a Compliance table where there are multiple countries listed in Country column, so I just created a distinct list of countries in the Country table.

 

Weekly Reporting table is a summarize from a date table where it list down the my reporting dates.

 

both tables look likes below:

Date
1-Jan-18
8-Jan-18
15-Jan-18
22-Jan-18
29-Jan-18
5-Feb-18
12-Feb-18
19-Feb-18
26-Feb-18
5-Mar-18
12-Mar-18
19-Mar-18
26-Mar-18

 

Country
USA
Switzerland
Germany
United Kingdom
Brazil
Sweden
Spain
Finland

 

So I wanted to create another calculated table that is a combination of both table above that will look like below that has a list of all countries every reporting week.

DateCountry
1-Jan-18USA
1-Jan-18Switzerland
1-Jan-18Germany
1-Jan-18United Kingdom
1-Jan-18Brazil
1-Jan-18Sweden
1-Jan-18Spain
1-Jan-18Finland
8-Jan-18USA
8-Jan-18Switzerland
8-Jan-18Germany
8-Jan-18United Kingdom
8-Jan-18Brazil
8-Jan-18Sweden
8-Jan-18Spain
8-Jan-18Finland
15-Jan-18USA
15-Jan-18Switzerland
15-Jan-18Germany
15-Jan-18United Kingdom
15-Jan-18Brazil
15-Jan-18Sweden
15-Jan-18Spain
15-Jan-18Finland

 

I am not sure how to formulate this in dax so any tips/help would be highly appreaciated.

 

Thank you

  • Hi Anonymous 

    You can use CROSSJOIN like below


    Table = CROSSJOIN(Country, 'Weekly Reporting')

    Hope this helps 
    Mariusz

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    Hi Anonymous 

    You can use CROSSJOIN like below


    Table = CROSSJOIN(Country, 'Weekly Reporting')

    Hope this helps 
    Mariusz