Forum Discussion

PatrickByGecko's avatar
3 years ago
Solved

Crossjoin between 3 tables with summarize and filter.. failure

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.

2 Replies

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