Forum Discussion

metin's avatar
metin
Frequent Visitor
5 years ago

Create a comparison column using 3 tables

Dear All,   I am working on a report that I need your help and ideas. I have 3 tables that I am working on direct query mode to create report.   These 3 tables looks like simply as below in terms...
Need Help
metin's avatar
metin
Frequent Visitor
5 years ago

Hi v-easonf-msft 

 

Thanks for the suggestion. I wasn't aware of this of function. I will work with this for some time.

 

My first impression is that it works fine with small datasets. However in my dataset, as you may guess product codes are repeated in several rows in all tables (different warehouse locations, orders and multiple shipments for in transit goods). Therefore sometimes the result of above formula sometimes gave inaccurate results.

 

I feel like, first I should have a measure to sum in each table per product code and then apply a formula using this measure. SELECTEDVALUE function didn't seem to work with this way.