Forum Discussion

Mohammed223's avatar
Mohammed223
New Member
2 years ago
Solved

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?
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

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