Forum Discussion
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 ...
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
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