Combine a date table with another dimension table without a key

[FelipeF]

Hello,

I have two tables, Table A and Table B. Table A combines a dimension and a column of values. Table B is a single column of Week as a name. This name is manually defined periodically in an attached Excel. I then have a slicer for Table B. I'd like to combine Table A and Table B, with a row created for each Week, then Site and Value. In the report I'd like to get the Value dynamically depending on which weeks or groups of weeks I have selected. See below for example. How do you recommend I go about this? I'm not very advanced so any help is appreciated.

Table A

Dim1	Value
ItemA	20
ItemB	30
ItemC	100

Table B

Week

Month1-1

Month1-2

Month1-3

Month1-4

Month2-1

Month2-2

Desired Result Table

Dim1	Value	Week
ItemA	20	Month1-1
ItemA	20	Month1-2
ItemA	20	Month1-3
ItemA	20	Month1-4
ItemB	30	Month1-1
ItemB	30	Month1-2
ItemB	30	Month1-3
ItemB	30	Month1-4

[amitchandak · Accepted solution]

@FelipeF , Use cross join

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

But it is Cartesian product 

[FelipeF]

Thank you, I can work with this! Can you please explain the implications of it being a cartesian product?