Forum Discussion
How to link Inventory table and Sales Table by Model ?
Hi All
How can i link inventory table and sales table model number = ABC ?
So that when i select model from ine=ventory table , i will also select sales table same model number = ABC
My PBU file :-
Paul
IM referring to the below. Also you could send to us the list of fields on both tables?
5 Replies
Anonymous , You need have to model in sales? if so, join both with common model dimesion and use model fom there
If model number is available on both tables then the join will be based on the field.
Also make sure on 'Models' section of Powerbi to select 'Both' and not 'Single' on Cross filter direction of the join
IM referring to the below. Also you could send to us the list of fields on both tables?
