Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need help with comparinmg 2 columns

Hi there,   I have two table A and B. Now i would like to sum up the Spend for all parts in Table B with a particular colour provided the parts are present in Table A. Table A Supplier, Part ...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

Need more details.Could pls provide a sample ,or share your pbix files.Remember to remove the confidential information.

Best Regards

Lucien

Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-luwang-msft 

Thanks for responding.Yes it is a one to many model and i somehow managed it.I used the in operator to see if the part in B is in A.