Merge columns, by comparing 2 criteria

[Sweet-T]

Hi everyone,

I'd like to merge two queries together, by comparing 2 columns. Is this possible? If not, any suggestions for a suitable work-around? 

I have queries 'Quota' and 'Forecast'. I would like to merge 'Forecast' with 'Quota' when :

'Quota'[Territory] = 'Forecast'[Territory] && 'Quota'[Date] = 'Forecast'[Date]

Any help would be greatly appreciated. 

Thanks!

Theo

[MFelix · Accepted solution]

Hi @Sweet-T,

On the query editor if you selecf the merge tables on the column selector if you press CTRL and the columns you need it is possible to merge table by more than 1 column.

Regards,
MFelix

[Sweet-T]

Can't believe I didn't try that. 

Thanks very much!