Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to link target table and sales table using Bridge ?

Hi All   I need to create sales target for my sales team.    Step 1 :- I create Target Table as below :-   SOURCE date_t GROUP_16  ODSE_target_sales_16 TS 01-Jan-20 MAX 66,666.00 ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, admin11 

     

    According to your requirement, I modify your bridge table code, then you can put the bridge table field 'staff' in the table1's value.

    Like this:

    Group16 = 
// DISTINCT (
//     UNION (
//         SUMMARIZE ( SALES,  SALES[Sales Staff] ),
//         SUMMARIZE ( TARGET_16, Target_16[GROUP_16])
//     )
// )
INTERSECT(DISTINCT(SALES[Sales Staff]),DISTINCT(Target_16[GROUP_16]))

    Best Regards

    Janey Guo

     

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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, admin11 

 

Thank you for your praise, I just try my best to realize your needs from your perspective. Can you give me kudos as a reward😊

 

Best Regards

Janey Guo

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

v-janeyg-msft 

Done, i Owe you one drink.