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,

     

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

Hi Anonymous ,

 

What is the format of the Time characterstics column in Power BI? Does other columns in two tables have the same name? Could you please provide a sample mockup table based on fake data or describle the fields of each tables and the relations between tables simply? Please don't have any Confidential Information or Real data in your reply.


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

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

                Q1        Q2       Q3      Q4

    X         200       350      300     250

    Y         450       400      300     250

     

    Regards,

    Ramki.

      • 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.