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.

 

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello Anonymous 

 

i would suggest you post here the current datatable from your Power BI (go to the Table in Power BI, click on the upper left symbol and select copy table) and post the table here in the forum. Please change them if contains sensitive data.

Please post also a table with your expected result and a detailed description how it's achieved (if needed).

 

All the best

 

Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Jimmy,

    Thanks for your help. I will try this option if not works again get back to you.

     

    Regards,

    Ramki.

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      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 Jimmy,

         

        It is working fine but I have used group by option  after I follwed you same what you said.

         

        Thanks for your help.

        Regards,

        Ramki.