Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Anonymous
You can use CROSSJOIN like below
Table = CROSSJOIN(Country, 'Weekly Reporting')
Hope this helps
Mariusz
Hi @Anonymous
You can use CROSSJOIN like below
Table = CROSSJOIN(Country, 'Weekly Reporting')
Hope this helps
Mariusz
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |