Join static pattern table to dynamic table

[vojtechsima]

Hello,

I have one table that contains 13 (static countries) rows for each week. I need to report all those rows every week, however, sometimes happen that I don't have data for some country, however, I still need to show the whole table with 13 rows per the week.

Is it possible to create a pattern static table where I would link the dynamic table, and if there are no values for the specific rows it becomes blank but it will be visible?

See pictures, the first one is the static pattern I need to show in the second table, as you can see there some countries missing due to lack of data.
I need to create dynamically so I don't have to copy-paste 52x13 rows (as I need for the whole year).

Thanks

[V-lianl-msft · Accepted solution]

Hi @vojtechsima ,

Please create 3 tables.

1. 13 countries

2. week: 

table 2 = GENERATESERIES ( 1, 52 )

3. crossjoin table:

Table 3 = CROSSJOIN('Table','table 2')

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

[vojtechsima]

@V-lianl-msft Hello,

this is exactly what I needed.

Thank you very much

[amitchandak]

@vojtechsima , Create a separate country column and join this table with that and try this option or add +0 to the measure

countrows(Table)+0