Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Peter Pan]

Hi all,
I have 2 tables, one is Product & one is Month (12 months), how can I join 2 tables together? I mean add every month from table Month to table Product like picture bellow?

Thanks for your help!

[Audrey Abbey]

Hi Tung,

These tables do not share a column. 
The results you show is called a Cartesian Product. 
In the code, we use a cross join to do that. 

DAX:
https://msdn.microsoft.com/en-us/library/gg492168.aspx

You can also add a Custom Column via Query Editor and add the query for one table as a column for the other. 
Or add a custom column to each table, and populate with the value 1. Then merge the tables on that column. 

I am sure there are a few other ways to achieve it…but that should get you started. 

Best, 
Audrey

——————————
Audrey Abbey
SR. BI Developer/Analyst
New Seasons Market
Portland OR
——————————
——————————————-

[Peter Pan]

Thanks for your information, Abbey.——————————————-

[Tara Prasad Gumansingh]

Hi Tung Pham,

Just create a relationship between these two tables on No.(If possible change the Month No. to only No.)
1 – While creating the report take the Month from Month table and the rest from other one.
2 – If you want the same thing on Data table then you can pull it by using Lookup formula.

——————————
Tara Prasad Gumansingh
Data Analyst
Bangalore
——————————
——————————————-

[Bruce Montemayor]

Why do you want to? If you are wanting to count or sum by month, the ideal thing would be to add a date table to the model and relate it to sales and orders and any other table containing dates. Then you will be able to aggregate counts and sums by any date dimension from any table. 

Thank You,

Bruce Montemayor

——Original Message——

Hi all,
I have 2 tables, one is Product & one is Month (12 months), how can I join 2 tables together? I mean add every month from table Month to table Product like picture bellow?

Thanks for your help!

[William Rodriguez]

Greetings @Tung Pham :

is correct. Below illustrates her ?recommendation

Thanks!
William

#DAX?

——————————
William Rodriguez
Business Analyst
——————————
——————————————-