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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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