Forum Discussion

ritu24raj's avatar
ritu24raj
Icon for Helper II rankHelper II
5 years ago
Solved

Combining values from two tables into one

Hi -   I need some help, in regards to merge the values from two different tables based on one value. Table 1 Table 2 As we can see the Revenue In and Revenue Out values are differen...
Need Help
Tips and Tricks
  • Icey's avatar
    Icey
    5 years ago

    Hi ritu24raj , 

     

    Since you are using SSAS >> Live connection, it is suggested to create a new table "Region", which contains regions both from "PO Contract Region" and "Delivery Region",  and create relationships among other tables in SSAS.

     

     

    Best Regards,

    Icey

     

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

ritu24raj's avatar
ritu24raj
Icon for Helper II rankHelper II
5 years ago

HI Anonymous - This is not working as expected.

  1. Revenue In and Revenue Out are two different measures
  2. Delivery Region and PO Region are coming from two separate objects

 

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi ritu24raj , 

     

    Since you are using SSAS >> Live connection, it is suggested to create a new table "Region", which contains regions both from "PO Contract Region" and "Delivery Region",  and create relationships among other tables in SSAS.

     

     

    Best Regards,

    Icey

     

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