Combine 2 column from different table become new table

[Prihatama]

Hy everyone,

I realy need your help. I have 2 table and i want combine it become new table like below picture.

I want the result like expected table.

Please kindly give advice.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

CROSSJOIN function (DAX) - DAX | Microsoft Learn

expected result table = 
CROSSJOIN('item', 'year')

[Prihatama]

Hi @Jihwan_Kim 

thank you,, it's work 🙂

very help me