Crossjoin between 3 tables with summarize and filter.. failure

[PatrickByGecko]

Hello

Is it possible to make a crossjoin between 3 tables with a filter on equality of Year and Month between them? I mean I only want the crossjoin work for the items which respect this equality?

Because the error message looks to say it is not, the columns I need and on the filter can't be used because they are present on Crossjoin Instruction. And when I suppres this columns on Crossjoin instruction, I'm told that they don't exist for the filter condition...

Here is the screen shot =>

Thanks for your help.

[PatrickByGecko · Accepted solution]

Thats's right, thank you very much.

[lbendlin]

Your crossjoin cannot result in duplicate column names. Rename columns like [Annee]  to remove the conflict.