actual vs plan

[Ajeck]

Hello , could anyone help me please, I'm new in this power BI

I want to compare between Actul with plan so  like this :

	January			February			March
Sales Code	Plan	Actual	Ach	Plan	Actual	Ach	Plan	Actual	Ach
A55	7500	6000	80%	10000	6000	60%	3000	6000	200%
C4DL	1500	2000	133%	5000	2000	40%	2300	2000	87%
T4F	7900	5000	63%	9500	5000	53%	2300	5000	217%
Grand Total	16900	13000	76.9%	24500	13000	53.1%	7600	13000	171.1%

i'm attaching pbix file 

https://ptaab-my.sharepoint.com/:u:/g/personal/akristyonoputro_asuransiastra_com/EXmrW0xPXclNhMvVfjX...

Thank you 

Rgds, Aji

[amitchandak]

@Ajeck , I have done some changes. The problem is that the Month is plans do not have a year. Prefer to convert into a month start date to make it work

[Ajeck]

@amitchandak , I can't download your file , 

could you upload it or sent by email please, otherwise i'll try for your suggestion

[Ajeck]

@amitchandak , sorry i mean i can't open your file ,

It said : "Object reference not set to an instance of an object.

Thank you

[Ajeck]

@amitchandak , Thank you, it works

[amitchandak]

@Ajeck , I created a common table

Sales Code = DISTINCT(UNION(ALL(Plan[Salesman code]),ALL(Sales[Salesman code])))

and joined with both tables

And a measure

Ach = DIVIDE(Sum(Sales[AMOUNT]),sum(Plan[Plan]))

But the problem is plantable have month name, not a date