Help

[Mohammed223]

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?

[PijushRoy]

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-overview

Then 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=sharing

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

[PijushRoy · Accepted solution]

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

[Mohammed223]

 For 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?