topic New tables with distinct values from two differents tables in DAX Commands and Tips

New tables with distinct values from two differents tables

PaulMGNT — Fri, 23 Sep 2022 16:09:26 GMT

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

Re: New tables with distinct values from two differents tables

tamerj1 — Fri, 23 Sep 2022 16:39:59 GMT

Hi PaulMGNT

if you are lioking for a calculated table then

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

Re: New tables with distinct values from two differents tables

PaulMGNT — Sun, 25 Sep 2022 14:54:52 GMT

Hi tamerj1,

this is great, thanks a lot.

Paul