Percentage between two columns in different tables with grouping

[Thomasp75]

Hello everyone, 

I am having an issue regarding the computation of what seemed trivial at first but has taken me way too long now.

I have two tables with 4 columns each : three column that share the same name and a fourth with the actual numbered value.

I want to be able to calculate the percentage of one table as compared to the other. For example, I have :

Table 1:

col1	col2	col3	col4
jan	aa	r	2
jan	aa	s	4
jan	bb	t	5
feb	aa	u	1
feb	bb	v	8
feb	cc	w	7
mar	aa	x	3
mar	bb	y	10
mar	bb	z	2

and table two with the same format. I want the output table to group by col1, col2 and col3 in both table and return the ratio of col4 between both tables..

I hope my question was clear enough...

Thanks for your help

Thomas

[Thomasp75]

Thank you Ahmed. However I am using calculated tables that are not available in Power Query... I would like to do it using DAX

[Ahmedx · Accepted solution]

ok, pls try

[Thomasp75]

Thank you so much ! Exactly what I needed 🙂 

Thank you Ahmed

[Ahmedx]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjDB4TUJfiY_RnnkS?e=HMuTaM