Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

You can use CROSSJOIN like below


Table = CROSSJOIN(Country, 'Weekly Reporting')

Hope this helps 
Mariusz

View solution in original post

3 REPLIES 3
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

You can use CROSSJOIN like below


Table = CROSSJOIN(Country, 'Weekly Reporting')

Hope this helps 
Mariusz

Anonymous
Not applicable

Thanks @Mariusz . This works.

Anonymous
Not applicable

@Mariusz  Thats great..!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.