Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Join between two extracted Bex Queries from SAP BW

Hi All,   I have extracted two Bex queries which are related to COPA flow and Shipment flow respectively in SAP BW. But I was not able to Join between them and not able to divide them. Actually I j...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Hi ,

 

Below are format which I had in power BI and which are Matrix format. I need to divde them and make it another table.

            Q1        Q2       Q3      Q4

X         800       700     600      500

Y         900       800     600      500

--------------------------------------------

 

Hi ,

 

Below are format which I had in power BI and which are Matrix format. I need to divde them and make it another table.

            Q1        Q2       Q3      Q4

X         800       700     600      500

Y         900       800     600      500

--------------------------------------------

            Q1        Q2       Q3      Q4

X         200       350      300     250

Y         450       400      300     250

 

Result :

 

          Q1        Q2       Q3      Q4

X         4          2          2         2

Y         2          2          2         2

 

Regards,

Ramki.

 

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

After unpivote two tables, we can merge them into another table.

 

Then we expand the value of table2 and create another column to get the divided value

 

 

At last, we can pivot the ID and Attribute column to get the disire table

 


Best regards,