HELP : HOW TO CONNECT PRODUCT TABLE INTO TARGET TABLE

[RanHo]

Good Day!

      I just want to ask how can I connect the 2 table I had so that I can compare the Product count and Target per month.
I need to get the count of Product and then compare it with a monthly target i created then show it on Matrix visual. Take note the Product Table I had is in SQL Database while the Target Table is in the Sharepoint List I made.  Here is sample tables/data and also the output I needed.

PRODUCT TABLE __ (SQL DATABASE)TARGET TABLE __ (SHAREPOINT LIST)DESIRE OUTPUT __ ( MATRIX /TABLE VISUAL
The Team has Target per Month, how I can achieved the Output I need? Is it possible ?any Ideas would be accepted. 
Thanks in advance!

_Ran

[v-stephen-msft · Accepted solution]

Hi @RanHo ,

Here's my solution.

1.Create a calculated table with companies.

2.Create a calculated column to get the short name of company. Short names are obtained to facilitate connections. Your target table shows companies in this format.

3.Create relationships.

4.Create measures to get the product count and taget monthly.

Measure = IF(FORMAT(MAX('PRODUCT TABLE'[entry date]),"MMMM")=SELECTEDVALUE('TARGET TABLE'[MONTH]),1)

ProductCount = SUMX('PRODUCT TABLE',[Measure])

Target Monthly = IF(ISBLANK([ProductCount]),BLANK(),SUM('TARGET TABLE'[TARGET]))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RanHo]

@v-stephen-msft  I'll accept it as solution Sir,  unfortunately not working on mine but on your sample file attached its working, so maybe I work on my database and figure it out. 

Thanks!

[RanHo]

@v-stephen-msft why when I'm creating this measure I'm getting a error 
Measure = IF(FORMAT(MAX('PRODUCT TABLE'[entry date]),"MMMM")=SELECTEDVALUE('TARGET TABLE'[MONTH]),1)

,
error# = Too few arguments were passed to the IF function. The minimum argument count for the function is 2. but I created measure similar, do I missing something?

[RanHo]

@v-stephen-msft I'll try this.