Forum Discussion
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.
| Date | Country |
| 1-Jan-18 | USA |
| 1-Jan-18 | Switzerland |
| 1-Jan-18 | Germany |
| 1-Jan-18 | United Kingdom |
| 1-Jan-18 | Brazil |
| 1-Jan-18 | Sweden |
| 1-Jan-18 | Spain |
| 1-Jan-18 | Finland |
| 8-Jan-18 | USA |
| 8-Jan-18 | Switzerland |
| 8-Jan-18 | Germany |
| 8-Jan-18 | United Kingdom |
| 8-Jan-18 | Brazil |
| 8-Jan-18 | Sweden |
| 8-Jan-18 | Spain |
| 8-Jan-18 | Finland |
| 15-Jan-18 | USA |
| 15-Jan-18 | Switzerland |
| 15-Jan-18 | Germany |
| 15-Jan-18 | United Kingdom |
| 15-Jan-18 | Brazil |
| 15-Jan-18 | Sweden |
| 15-Jan-18 | Spain |
| 15-Jan-18 | Finland |
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 belowTable = CROSSJOIN(Country, 'Weekly Reporting')
Hope this helps
Mariusz