New tables with distinct values from two differents tables

[PaulMGNT]

Hello,

I have a new PBI challenge for myself, I new to create a table that duplicate distinct values from two tables. One column is calendar(date) (from calendar table), the second column is product(id) (from product table).

Below is an example of what I need.

Date	Product_ID
01/01/2022	44
01/01/2022	45
02/01/2022	44
02/01/2022	45

I really don't know if it is possible to do it threw DAX.

Thanks a lot for your help,

Paul

[tamerj1 · Accepted solution]

Hi @PaulMGNT 

if you are lioking for a calculated table then

CROSSJOIN ( VALUES ( 'Calendar'[Date] ), VALUES ( 'Product'[ID] ) )

[PaulMGNT]

Hi tamerj1,

this is great, thanks a lot.

Paul