Create a Panel Data table from two different tables

Anonymous,

Try this solution.

1. Create a table with years:

2. Create a calculated table:

Table3 = CROSSJOIN ( VALUES ( Table1[Category] ), VALUES ( Table2[Year] ) )

Result:

Hi Anonymous 

I'm a bit confused as to why ID 1 has become 2017?

If you want to just add a date to the table you could consider using CROSSJOIN()

Let's say you have a date table as the following：

and then another table like this

When a new table is created using CROSSJOIN()

New Table = CROSSJOIN('Table','Date table')

Result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.