Forum Discussion
Join between two extracted Bex Queries from SAP BW
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,
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.
Hi Anonymous ,
We can try to append two tables after unpivote them, If it doesn't meet your requirement, could you please show the exact expected result based on the Tables that you have shared.
Best regards,
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.
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,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
Hi Jimmy,
Thanks for your help. I will try this option if not works again get back to you.
Regards,
Ramki.
