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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.