Forum Discussion
Help
If I have two tables in the dashboard and I want to divide the results of the two tables together so that the results are new in another table, such as Excel, how can I do that?
Hi Mohammed223
Your question regarding the report or Dashboard?
Please share a screenshot of the question (with the expected result)
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 👍
Thanks
Pijush
3 Replies
Hi Mohammed223
Your question regarding the report or Dashboard?
Please share a screenshot of the question (with the expected result)
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 👍
Thanks
PijushFor example, for the two tables, I want to divide the number 5 by 2, (5/2). The result of this division is in a separate table. How can I do it in Power BI?
Hi Mohammed223
Column name in your table should be different, both table all rows showing same "g", this should be different.
Please Marge query as New, so it will create a new table for you. Use 1st column for both tables as your Join
https://learn.microsoft.com/en-us/power-query/merge-queries-overviewThen both table data in the same table and create a custom column for all columns for dividing.
I have created sample pbix file for you, download, go to Power Query and check the steps.
https://drive.google.com/file/d/1gSyTaN9qLUmzYMwul37Z4FSxmsqLLr67/view?usp=sharingIf solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
