Forum Discussion

Solution Specialist

4 years ago

hi

hi, I attached an excel file where I need a sales representative to target each month need a measure Marketing Reprsentative Name Item name Month Target (in % percentage) A pen ...

Super User

4 years ago

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.

Solution Specialist

4 years ago

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

abc_777
Solution Specialist
4 years ago
I updated my query for better understanding.
- abc_777
  Solution Specialist
  4 years ago
  how can i do this measure
  
  if
  jhon then (total sale * 0.1)
  if
  Dan then (total sale * 1.1)
  if
  Bill then (total sale * 0.5)
  
  also i want to put marketing person (Jhon, Dan, Bill) in slicer selection
amitchandak
Super User
4 years ago
abc_777 , we can this year vs last year using date and time intelligence or using year table.

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

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
- abc_777
  Solution Specialist
  4 years ago
  please try to understand for retail industry company give target depends upon last year sale to each market person and check his achivement. if u have any pbi file for that please share rather just put some link.
  
  thank you