hi

Question

hi,&nbsp;I attached an excel file where I need a sales representative to target&nbsp; each month&nbsp;&nbsp;need a measureMarketing Reprsentative NameItem nameMonthTarget (in % percentage)ApenJanuary5%BPencilFebruary15%CNotebookMarch10%AStaplerJanuary10%ANotebookJanuary20%DRubberApril5%BPencilApril25%

amitchandak · Answer

abc_777 ,The information you have provided is not making the problem clear to me. Can you please explain with an example. Appreciate your Kudos.

abc_777 · Answer

Hi,&nbsp;&nbsp;Here i have stated what i m looking for. for simple understand I have mentioned here as KG but would be good if i get in percentage.&nbsp;&nbsp;Marketing personsold last yeartarget this yearThis year current sale (achievement)Target vs this year current sold (achievement)&nbsp;robin50 KG52.5 KG20 KG32.5 KG&nbsp;Jhon70 KG85 KG35 KG50 KG&nbsp;Nill90 KG100 KG55 KG45 KG&nbsp;&nbsp;thanks

abc_777 · Answer

still waiting if anyone has any solution for target Vs actual sale = achievement&nbsp;

abc_777 · Answer

I updated my query for better understanding.

amitchandak · Answer

abc_777 , we can this year vs last year using date and time intelligence or using year table.
&nbsp;
But we can sum up number, and can diff using that.
For the % symbol, we can mark the measure as % measure using the measure tool in the ribbon, available once you click on the measure
&nbsp;
Power BI — Year on Year with or Without Time Intelligence https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38ahttps://www.youtube.com/watch?v=km41KfM_0uA

Forum Discussion

hi

7 Replies

Marketing Reprsentative Name	Item name	Month	Target (in % percentage)
A	pen	January	5%
B	Pencil	February	15%
C	Notebook	March	10%
A	Stapler	January	10%
A	Notebook	January	20%
D	Rubber	April	5%
B	Pencil	April	25%

Marketing person	sold last year	target this year	This year current sale (achievement)	Target vs this year current sold (achievement)
robin	50 KG	52.5 KG	20 KG	32.5 KG
Jhon	70 KG	85 KG	35 KG	50 KG
Nill	90 KG	100 KG	55 KG	45 KG